SQL Problem

[werks]

Error: No value given for one or more required parameters.

"INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "', Date, "2")"

Please help me on this one..

--
Kenneth
"Better Than Yesterday"

[markrawlingson]

Try this...

[code=asp]
"INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "', getDate(), "2")"

'Or

"INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "'," & Date & ", "2")"
[/code]

Hope this helps..

Sincerely,
Mark

Error: No value given for one or more required parameters.


"INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "', Date, "2")"

Please help me on this one..

--
Kenneth
"Better Than Yesterday"

[werks]

Still have error

Error:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement

SQL1 = "INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "'," & Date & ", "2")"

--
Kenneth
"Better Than Yesterday"

[DrBunchman]

Still have error

Error:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement

SQL1 = "INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "'," & Date & ", "2")"

--
Kenneth
"Better Than Yesterday"

Hi Kenneth,

At the end of your string you've got double quotes around the 2 when you don't need them, which is closing your string prematurely. Your string should look like:

SQL1 = "INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "','" & Date &[b] "', 2)"

Hope this helps,

Dr B

[werks]

Hi Kenneth,

At the end of your string you've got double quotes around the 2 when you don't need them, which is closing your string prematurely. Your string should look like:

SQL1 = "INSERT INTO tblBook_Loan (AccessionNo, BorrowerID, DateBorrowed, Status) VALUES ('" & varAccession & "', '" & varBorrower & "','" & Date & "', 2)"

Hope this helps,

Dr B

Thanks Dr. B it works..

--
Kenneth
"Better Than Yesterday"

[werks]

Also thank you markrawlingson