I have been trying to do this code but I cannot make it works. Could you help debugging the code.I dont know if the code is in the correct syntax or not.
I place this code at the top of all my page to check an invalid user that are trying to access the page without logging in. When they are success, I want to update a field to store the current time ("LastActive" field)
When the user login, I ask for their Username and password!and then, reffering to this username, update the LastActive field.
MySql="UPDATE country SET country.country_name='" & country_name & "' WHERE country.country_id =" & country_id & ";" Hi, My question relates to the quotes in the above query. I was able to find my probem by searching the forum, but I am interested in knowing why I must use single quotes around the following: Code:
strQuery2 = "Update tbCard_Temp Set tbCard_Temp.Id='tbCardSwipe.Id From tbCardSwipe'" and i get this message [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tbCardSwipe.Id From tbCardSwipe'.
with the syntax below wouldn't it update all acct stats with the name potential client where before the values were set to 0? Am I writing this correctly? User_info is the table and i don't know whether or not if it goes in there. update user_info set acct_stat Potential Client where acct_stat = "0";
I'm having trouble with an SQL UPDATE string updating Microsoft Access 2000 with jet engine using ASP classic. I can't see what could be going wrong, as far as I can tell it's fine. I have tried surrounding my field names with brackets [] to no avail.
I am trying to modify and update a column in the access dB by using a form on the first page, and then the update sql statement on the second page.
For some reason the error its throwing at me is this
Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /willdata/password.asp, line 34
When I use the same update statement directly into the access dB it works, if I even hard code in values in the ASP page I still get an error - I now cannot see for looking: Code:
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'm just trying to display a user's FIRST name and the FIRST INITIAL of the last name on my asp web page. This works to displays their "firstName" and "lastName":
Code: <%=oUsers("firstName")%> <%=oUsers("lastName")%> But I get a variety of vbscript or asp syntax errors when I try to trim the "lastName" using something like
Code: <%=oUsers("firstName")%> <%=oUsers(replace(left("lastName",1))%> How do get this simple task done?
(If it makes any difference, the whole thing is inside html <td></td> tags as part of a table)
The WHERE part of my select needs to pull out where the date column is empty. If there isn't a date, it shows NULL in the database (SQL7)."WHERE eligibility_dt <> NULL" doesn't work. what am i forgetting?
I believed that there is a wrong syntax on the window.open line...Can anyone spot it ? Code: strLocation = "Sch_As_FollowAct.asp?drvid=" & request("drv") & "&u=" & uday(0)
i am having some trouble rembering the correct syntax for a If Then Statement here is my code.
<% If Request.QueryString("access") = "false" Then %> <tr> <td colspan="2" bgcolor="#FFFFFF" class="mediumRed">The User ID and Password combination has failed.<br> <br> Please try again.</td> </tr> <% Else If rsGettblCouples.Fields.Item("StopDate") = "1/1/1900" Then %> <tr> <td colspan="2" bgcolor="FFFFFF" class="mediumRed"> The User has already<br> completed the online scoring.<br>Please Contact your facilitator.</td> </tr> <% End If %> <% End If %>
Can someone direct me a set of rules for building strings in ASP? I'm always getting stuck on when to use a quote (") or apostrophe{'} or both. This simple string is giving me fits...
I want to update multiple rows in an SQL table. Presently, it's populating all rows with the same data based on the first row. It's not looping through all records one at a time. Is this the correct syntax.
<% rsOD 'recordset up here %>
<% Dim DataConn1 Set DataConn1 = Server.CreateObject("ADODB.Connection") DataConn1.Open MMSTRING Do While Not rsOD.EOF 'SQL UPDATE statement here DataConn1.Execute(SQL) rsOD.MoveNext Loop %>
Another slight problem with syntax of asp, basically I'm pulling an image file name from my database (image1.jpg) and using the images directory on my web server to display my picture, make sense? Code:
If you haven't noticed I am novice and have just started getting back into the world of ASP. First question can I have two And statements, and second the syntax is wrong with my And statements where can i find a reference to see the proper syntax. Code:
