Error on SP insert

message from Zwi2000 on 19 Jul 2004
I am inserting a value into a bit field using a SP.

Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/gtlawbluedot/Intranet/Contacts/SetNoCurrent/I94.asp, line 58

It is the only value giving the error, I have double checked. Shouldnt
values for bit be : "1" and "0" ?

Z
 
Julian Roberts replied to Zwi2000 on 19 Jul 2004
In the Command behaviour, use a Type of Integer for the parameter.
 
Zwi2000 replied to Julian Roberts on 19 Jul 2004
Thanks .. quick question.

For a date field if the field is empty (NULL), what should I enter in
default value to also leave field NULL.

I tried "NULL" but didnt work.

A

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:cdhgob$nq1$1@forums.macromedia.com...
 
Zwi2000 replied to Zwi2000 on 19 Jul 2004
Got it, took off the "" in code view.

Z

"Zwi2000" <zwi2000@hotmail.com> wrote in message
news:cdhiq8$psc$1@forums.macromedia.com...
 

Archived message: Error on SP insert (Macromedia Dreamweaver)