hi Rabbit,
Just to say first of all thanks for looking at my problem, appreciate it.
After considerable research have finally found the correct format. Turns out that I had got it right before but that there is a problem with 64 bit OS, access 2010 and ADO/ASP conversion.
Working with strings is fine but the minute you try to convert there is a problem. They have suggested some resolutions and patches so...
ANNIE4
Last Activity: Apr 21 '12, 05:02 PM
Joined: Apr 13 '12
Location:
-
Hi Rabbit,
Just wanted to apologise for lack of code tags.
Still having the same problem, just doesn't seem to work with any conversion that I use. I'll keep plugging away. Thanks.Leave a comment:
-
Thanks so much for getting back to me appreciate it, but unfortunately
error code now is:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
Here's the code up until now:
sql=sql & "('"& int32.convert(R equest.Form("S_ id") & "',")
/sparqs training site/Attendance.asp, line 12Leave a comment:
-
I am trying to convert string to int, date, time for access database
Hi everyone, I am new to this so I have been trying to convert input from form (string) to different data types but can't get it to work. Keeps telling me there is syntax error or expected ')' no matter what way I write it. Have tried everything I think. Here is my completed code. If anyone can help I would be extremely grateful and thanks in advance.
...Code:<html> <body> <% set conn=Server.CreateObject("ADODB.Connection")
No activity results to display
Leave a comment: