No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Here is a pretty standard Verify script which searches through a database for specific records and sends the user to the next page if the record is found. The problem the script seems to be unable to find certain records (6 our of 28 in this case). I have tried … |
|
I'm using this code to place Time\Date stamps in specific Access Columns: [code=asp] Dim conn,strsql,sql_update,ssn,cps,hdDate,TOD,PageDate,h h=hour(now()) ssn = "Select SSN From CWCT07 where SSN = '" & Request.Form("SSN") & "'" If _ (Request.form("PageDate")) = "1/30/2007" And "h" < "12" _ Then _ sql_update = "Update CWCT07 Set Jan30AM = '" … |
|
Have gotten the select statement and Update statement to work separatly, but need them to work on the same page and cannot seem to make it happen. Here is the current state of things. Any help would be appreciated. [code=asp] <% Dim conn,rs,strsql,sql_update,ssn,cps strsql = "Select SSN From CWCT07 where … |
|
I hope someone can help me decide what is happening with this. It recognizes and carries out the select statement, will redirect to the proper place if entry is valid/invalid, but will not insert anything into the database. I first wanted an timestamp but am trying to troubleshoot backwards and … |