UPDATE Method In ASP,SQL
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:
View Complete Forum Thread with Replies
Related Forum Messages:
ASP Update Method
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 W2003 + IIS6.0
View Replies !
Update Method
I use the following to update: Dim rsEdit1 Set rsEdit1 = Server.CreateObject("ADODB.Recordset") rsEdit1.ActiveConnection = MM_shop_STRING rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12" rsEdit1.CursorType = 2 rsEdit1.LockType = 3 rsEdit1.Open() rsEdit1.("authorMemo") = "TEST" *Error message from this line rsEdit1.update rsEdit1.Close() Set rsEdit1 = Nothing The problem is that I keep getting the following error message : "Microsoft VBScript compilation (0x800A03F2) Expected identifier"
View Replies !
Method To Display/update Dynamically
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.
View Replies !
How To Tie RegID To Form To Update (batch Update)
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:
View Replies !
ASP Method
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
View Replies !
Using Get Method
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.
View Replies !
Method Not Allowed
Method Not Allowed The requested method POST is not allowed for the URL /Database/processForm.asp. Apache/1.3.33 Server at antonyx.freestarthost.com Port 80 i just got this error, however, i have managed to post data into my database on this server b4, why is this error comin up now, could there be a prob with my asp file??
View Replies !
GetString Method
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: while not rsClient.EOF Response.Write chr(9) & "MenuForm.lstClient.additem " & chr(34) & replace(rsClient.Fields("Client Name").value,chr(34),"'") & " [" & trim(rsClient.Fields("Client Number").Value) & "]" & chr(34) & chr(13) rsClient.MoveNext
View Replies !
POST Method
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
View Replies !
Post Method
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:
View Replies !
ASP HTTP GET Method
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?
View Replies !
Best Method To Hide
What's the best method to hide, or not show a certain record when doing a pull from a database, as in I am pulling a list with a dozen category's and I don't what to show one of them.
View Replies !
ASP POST Method Bug
I have a demo.asp page, that can't pass hidden value "mr progrramer" to itself using POST method. Only "mr" is passed. I created a second asp file demo1.asp and passed "mr programmer" and whole string (include space b/w mr and programmer was passed successfully). The code for demo.asp is: <% name = request.Form("name") response.Write "hello " & request.Form("name") ' if name is empty then store some string with space in it ' problem is the word before space 'mr' is passed, but 'programer' is not passed if len(name)=0 then name = "mr programmer" end if %> Code:
View Replies !
POST Method
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.
View Replies !
Using The Find Method
Based on what the user selects in a combo box I need to find the value from another column in the same record. This is what I am using: rsPrice.movefirst rsPrice.Find "Component='Desktop'" If (rstPrice.BOF = True) or (rstPrice.EOF = True) Then response.write("The Price for the Component Not Found") else curPrice =rsPrice("Score") End If I keep getting an error messages: Microsoft OLE DB Provider for SQL Server (0x80040E29) Rowset does not support scrolling backward.
View Replies !
Renaming Method
I'm looking for a renaming method for folder objects.I have an ASP (JScript) application that I'm creating that acts as a document library. Users can upload files, create folders, etc. Most places I go to basically have: copy, delete, move, create textfile as the only methods for the folder object - NOTHING about renaming.
View Replies !
Search Method
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?
View Replies !
Execute Method.
can i gain the two result. in an asp page which using a stored procedure with execute method. i want to execute the query and return the count value the query at the same time. is it possible and how?must i use ado? it is not possible to make it with execute method in asp.
View Replies !
MapPath Method
I am coping a file from server to local on my computer using: fso.CopyFile Server.MapPath("downloadworkfile.htm"), Server.MapPath("p:workingworkfile.htm"), true I am getting MapPath method must be a virtual path. How do I reference a virtual path?
View Replies !
GetRows Method
When querying a database, I know I can fix the no. of returned rows/results to 20 (for example) using the GetString method: myVar = objRs.GetString(, 20, , ,) What syntax do I need to use to do the same with the GetRows method: myVar = objRs.GetRows ?
View Replies !
Replace Method
I can see how this works, but can anyone clarify what purpose the 1, 1 serves? Code: strSearchKeywords = replace(strSearchKeywords, ",", "", 1, 1)
View Replies !
GET Or POST Method
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.
View Replies !
GetTempName Method
why the method GetTempName produced rad as the first 3 characters before giving random letters and numbers? It seems pretty pointless.
View Replies !
ADO Find Method
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.
View Replies !
FileExists() Method
Here is my the relevant code: <% 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?
View Replies !
Post Method
I hv an asp page that allows the users to enter two dates, when they click a button i have another asp page that is opens word and shows the results in a table. in order to get the criteria i think i need to use the post method for the page that opense word. however i ahve done a search and can not see anything that properly explains this method.
View Replies !
POST Method
I'm having trouble reading data that i send to the server using ajax. The call am making in the client-side javascript is: fullProject.open("POST", url, false); fullProject.setRequestHeader('Content-Type','application/x-www-form-urlencoded'); fullProject.send('var1=' + projectData); and I want to know how to grab that data using asp. The call that I've been manipulating is <% response.write "data: " & request("var1") %> That hasn't been working, and all I've been receiving back is the string "data: ".
View Replies !
Preferred Connection Method?
Which of the following would be the most preferred connection string method? What is the difference? strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/marketing/ics.mdb") strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/marketing/ics.mdb")
View Replies !
OpenTextFile Method Not Working
I am trying to open a text file to read the contents using the following code: Dim objFSO, objFile Const ForReading = 1, ForWriting = 2, ForAppending = 8 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("c:inetpubwwwrootDemoAppscontenido.txt",ForReading) The problem is that the execution stalls at the OpenTextFile method and stays there until the script timeout error. The FileSystemObject is correctly created because I have been able to create a drive object and display the volume name, but actually trying to read or create (with the CreateTextFile method) a file is not working I am using IIS 5.0 running on Win 2k Pro
View Replies !
Error 405 Method Not Allowed
I have created a form using post which directs to a psmail.asp page. i keep getting the following when submitting the form. Can anyone suggest what i may have done wrong? Error 405 Method Not Allowed The requested method POST is not allowed for URL /html/psmail.asp Powered by Zeus Technology i dont understand why it is not allowed.
View Replies !
XMLHTTP Send Method
I cant use Microsoft.XMLHTTP object's Send method for posting a form. Can anyone help? The form field is <input type="hidden" name='content1' value='Add User'> But when i post objXMLHTTP.Send "content1=Add User" an error occurs. Neither of these works: objXMLHTTP.Send "content1='Add User'" objXMLHTTP.Send "content1=""Add User"""
View Replies !
SIMPLE Upload Method
I'm currently using CDO to email the values of a form and add the values into a database table. My goal is to attach a MS Word document (.doc) to the email before it's sent without adding it to the database (not required). I've tried molding other "simple ASP upload" methods, but I can't seem to make them work without success. Maybe you guru's can assist me. 1. My field ID for the file to upload is "datafile". 2. I want to save the file to a relative directory on the site without specifying the full path. The path I wish to use is "/DB" for the DB folder. 3. After storing the file in the DB folder with the name of "Resume.doc", I want to use AttachFile to insert it into the email.
View Replies !
Server.Transfer Method...
Got a quick query in relation to the Server.Transfer method available in IIS 5+/ASP. I've got an issue where I want to take a portion of an online app and extract this out into a web site on its own, so I will end up having two web sites. This planned to aid problems we've been having with performance, as if the portion (which is an app in its own right) has problems we then have to restart the whole site and so bring everything down just because of the portion of the app which we're having issues with. Taking the portion of the site will allow us to run it in isolated mode in ISS and so just restrat that if needed, while not affecting the rest of IIS. Anyways, I'm in the process of writing a jump page to facilitate the process of moving from the first site to the new second site, but as we need to reuse session info created in site 1 I need a way of passing this over to the second site. I've been aware of the Server.Transfer but never really used it so I'm not too sure how I can actually use this. I was planning to write an ASP page that takes the required info out of session is site 1, calling Server.Transfere to send it over to the second site. I don't want to do a Response.Redirect, not wanting the client to do this and not allowing it to know what info I'm using in the session. And so, I thought the Server.Transfer would facilitate this, but after reading some of the documentation on MSDN I'm not sure I can, ie: redirect to another ASP page in this way and tack on a QueryString holding all the session info I need, as MSDN says that I'll get an 'ASP 0173 error, "Invalid Path Character"' error if I have a question-mark '?' in the path, or any other of a list of invalid chars. But then I need this '?' char to build my QString ie: XXX.asp?sas=123&jdy=0689... So what I'm after is some clarification that I can use Server.Transfere in this way or not, ie to redirect to an ASP page and tack on a QueryString, of if it just allows for an ASP page without s QString. So then if I want to do this I might need to use the Response.Redirect method, or some other way!! MSDN also says: "When you use the Transfer method, the state information for all the built-in objects are included in the transfer. This means that any variables or objects that have been assigned a value in session or application scope are maintained" ....So will I have the session info from site 1 available in site 2 after the redirect or does this only apply for a Server.Transfer within the same web (which I think is what it means!). I don't have an environment up that I can test this on yet so I'm kinda feeling may wat in the dark here, hence my lengthly post.
View Replies !
Server.mappath Method
I need to map a path to my database file automatically, if I move the application to a different direcotry level I still have to write part of the path to get the application to work. Is there anyway I can translate the directory path and place inside the mappath function so I dont have to manually edit it? cst = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("shopsmartnetworkcartcart.mdb")
View Replies !
The Easiest ASPUpload Method Ever?
What is the easiest method of using ASPUpload? Has anyone got any good example source code to view? I've looked at Persits example information and I'm having trouble understanding it. My form consists of a file input field (name="filUpload") and I want to submit the form to the same ASP page.
View Replies !
Object BinaryRead Method
It became clear to me that using a Request.Form object doesnt work after a Request.BinaryRead. I never had to deal with the BinaryRead Object Method, so this is quite new for me. I'm using a script to upload files to my server (this script uses the Request.BinaryRead). Besides the file, users submit there name and a checkbox (if checked of course). I want to use the data submited by the user, but the Request.Form object doesnt work .how can i access the tekstfield and checkbox, if cant use the Request.Form object?The answer will be simple probably, but my searches on google didn't give me an answer.
View Replies !
Recordset Find Method
I have a recordset of which when a page loads, I want to move to a specific record whose ID is equal to request("recipe"). The ID field is the primary key in the data set and is set to auto number. Is that my issue? The value on the url http://localhost/tasty_tuscany/tuscany-italy-recipes.asp?category=3&recipe=15 for recipe is coming in as a string? I tried converting it using the Cint() method but no dice. I would think it would work like this: Dim temp temp = Cint(Request("recipe") rs.Find "ID = temp" Is that not right? Maybe I need to Cint the rs("id") first?
View Replies !
FSO Object, Write Method
I am writing a VBS File Which will Take Data from an SQL Database and put it into a text file. I am getting an error on: myFile.Write NewLine (myFile is set to FSO.CreateTextFile, and NewLine is the text I am trying to write) I have found this error is being produced When I try to "write" this text from the database: <p><b>Movin’ On Printed Throw Blanket</b></p><p> The Problem is on this "Square" Charecter. I used the Asc() Function and got the Charecter value as 63, and Did a replace on it and it still does not work. I don't know how this charecter got in the database in the first place. I don't know if that charecter will show up correctly on this forum. But the character just looks like an empty box.
View Replies !
Database Connection Method
what is more efficient, opening the database once in the beginning of the page then closing it at the end of the page, or opening the db connection each time you need it. for example: i have a page that executes 50 queries. is it better to open the db, execute the queries, then close it, or to open and close the db 50 times?
View Replies !
ASP Classic: Sleep Method
i must confess I have only ever done one website in ASP (classic), and a crude one at that too. So please forgive my stupidity that I'm about to throw at you. Anyways, I have been told to fix some ASP code (developer already left the company) - the code in question contains an ungodly amount of database selects/inserts/updates in while loops, and every time the script is run it bogs down the server (sometimes crashing the server too!). So I was thinking maybe a quick way around this is to put in some sort of "sleep" calls during the execution of the script... though I don't know the syntax for it or even if such a method/function exists in ASP classic.
View Replies !
Session_OnEnd Method Not Firing
My Session_OnStart works but Session_OnEnd does not work. Here's the code...can anyone tell me what's wrong with my code or if anything else on the server that needs to be changed. The Session_OnStart does create the folder for me with the SessionID as the folder name but Session_OnEnd does not delete that folder. Code:
View Replies !
Using Redirect With Post Method
how can i (if at all possible) use post with response method? before i always did something like this to pass variables to the nest page: Response.Redirect "main.asp?per=" & per this obviously creates a querystring and that i am trying to avoid... so, if anyone knows how to do this please pass it on.
View Replies !
Encenctype And Post Method
I'm trying to sent information from a form to the server using the post method. The problem I'm having is that I have a file form field and it reqiures enctype="multipart/form-data". With this enctype, the data from the text fields doesn't get passed to the server. Is there a way around this?
View Replies !
|
TRACKER
