i am trying top update a field in my sql database but it wont let me??? does anyone know if my syntax is correct?? I have a field called userId in the database and want to replace it with my form request. Code:
The Folowing code is not working anymore.(500 error)
Set objRS = strSQL1.Execute strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID) objRS.Open strSQL1, objConn , 2 , 3 , adCmdText If not (objRS.BOF and objRS.EOF) Then [ objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1 objRS.update End If objRS.Close
The .execute Method works fine
strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID) objConn.Execute strSQL1
I'm looking for a few methods for displaying contents of a recordSet, displaying the recordset in a table format, allowing the user to update the information they want to modify, then saving that info back to the database. I know of a couple of ways of doing this:
Create an html table dynamically from the recordset, assign the values html ids, write the info back to the recordset on form post and update the db. OK, that's the only way I know.
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
I have downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it. if anyone has successfully generated the DiscID within an asp page? Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that
I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.
Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.
When using ActiveX Combo Boxes, can you use the GetString method to populate the control? I currently am using AddItem, however, it is taking a long time to process. I know that GetString works well to improve the performance. Here is my code while using AddItem:
Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before? Edit: By the way -- this is normal VBS/ASP running on IIS 5 on an NT server
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.
But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.
I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:
I have a service provider that's sends sms messages from clients mobile phones to my asp page, problem is I don't know how to show the data and they are not being helpful. The process is simple as outlined below (instructions from service provider
Example: If you provide this: http://www.yourdomain.com/sms/sms.asp then we will do a post via a standard HTTP GET as follow:
http://www.yourdomain.com/sms/sms.a...ISO-8859-1&udh= How do I receive the url with the parameters in the address bar?
I have a .asp page that uses the post method and it works fine on my computer using iis. But when i put it on the web server (it has windows NT4) it wont work.
I've read that you have to do something to allow the post method on the server.
i know nothing about windows NT4 but can get access to the server. can someone please let me know what i have to do to get this to work?
Just to let you know the post method is for ssending a login and pass to another page that search a database for the record. If there is another way to do this that does not show the variables in the url please let me know. i am also willing to make it so that everything is on the same page so i dont have to pass anything.
i have a search page script which consists of a text field and a pulldown menu. the search function using search text works but not the pulldown menu. do I have to set separate recordset for each of the search functions, one for the search using text field and another using pulldown menu?
when we should use GET method, when we should use POST method? GET method only sends limited amount of data, and it will show the data as part of URL. POST method won't show the data as part of URL, and can send any amount of data.
I am attempting the following for a real estate website. I want to list the agents for the office all of whom have a unique identifier with an Auto Number type. As I loop through the recordset, I also want to open another table called listings. This table has a field called agent whose value is a number and corresponds to an agent in the agent table.
If there is a listing in the listing table, I want to insert a link to "View Listings", if not, no link. I am having a hard time doing this and if someone could point me in the right direction I'd appreciate it. I tried the Find method but to no success.
<% set fs=Server.CreateObject("Scripting.FileSystemObject") If fs.FileExists("index.stm") Then CODE HERE Else CODE HERE End If %>
The problem is this: fs.FileExists("index.stm") always evaluates to false, even though I'm staring at the file "index.stm" as I type. In fact, I can open the file just fine, using the OpenTextFile() method. Checking to see if the file even exists is the problem. Anybody have any ideas?