Thanks to you guys for all your help, but as things still aren't working i'm obviously going to have to go and start from scratch again but this time rather than jumping into it i'll have to do a lot of reading first so i can understand what i'm supposed to be doing.
It's taught me not to...
Ok i've taken out the last " and i'm still getting...
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/Haraam/wis.asp, line 114, column 30
Set MM_editcmd = ObjConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &...
ok, now i've taken out the & ";PWD=mypassword part, and changes the name of the db to one with no space or 's the script looks like this...
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editconnection = Server.CreateObject("ADODB.Connection")
Set MM_editCmd...
ok so this is what i've done.
does it look right?
If (Not MM_abortEdit) Then
' execute the insert
Set MM_editconnection = Server.CreateObject("ADODB.Connection")
Set MM_editCmd = Server.CreateObject("ADODB.Command")
ObjConn.Open "DRIVER={Microsoft...
onpnt
do you close that connection after the script is done - how & where?
Yes post the INSERT statement - how & where?
and for the moment i'm still testing it all so what with these problems none of the pages actually link together because i get these probs.
Hey i've an idea why don't i...
mwolf00
ok as i said i'm a newbie.
where you've put yourConnectionStringGoesHere
what would that be? is it just the location of the DB, i.e. c:/blahblahblah, or is it something more?
please be patient. i really REALLY do appreciate you helping.
ok i appologise that previous error where i say it's an earlier page isn't it's the different version of the page in the first post. sorry. I will be using that page aswell so i need help there anyway.
The page that will be prior to either of the others comes up with these errors depending on...
i use the same database in an earlier page, but that has the same problem aswell, but on that page the error is...
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/haraam/Nowi.asp, line 115
I won't post...
OK, I may be being stupid but i can't find that in there anywhere! So i assume i need to put it in, but where do i need to put it, at the start or end, etc?
Thanks for helping me.
Firstly i'm a newbie at this kinda thing. So please any help you can give, do so in a step by step process in case i have no idea what you mean!
Ok, here's the problem....
I've been asked by a friend to make a site for their dance troupe, including booking form. I've done what i can so far but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.