Re: queryparam problem

I'll keep that in mind. Thanks Phillip B. Barney Boisvert wrote: > If "it" is the database, it's worth mentioning that database errors always > point at the last line of the CFQUERY tag's body, regardless of where the > error occurred. > > Cheers, > barneyb > > [Todays Threads] [This Message

RE: queryparam problem

uesday, May 18, 2004 12:08 PM > To: CF-Talk > Subject: Re: queryparam problem > > You were right. It was giving the wrong line in the error. There were > two fields that I was passing a null value to and it didn't like it. > Best error message ever. :-| > > Phillip b

Re: queryparam problem

You were right. It was giving the wrong line in the error. There were two fields that I was passing a null value to and it didn't like it. Best error message ever. :-| Phillip b Bryan F. Hogan wrote: > Try changing it from cf_sql_tinyint to cf_sql_integer if you haven't > done so already. > >

Re: queryparam problem

What happens if you try the INSERT without the cfqueryparam? I'm not suggesting this is good practise, but it will help isolate the problem.   - Original Message -   From: Bryan F. Hogan   To: CF-Talk   Sent: Tuesday, May 18, 2004 2:39 PM   Subject: Re: queryparam problem

Re: queryparam problem

Try changing it from cf_sql_tinyint to cf_sql_integer if you haven't done so already. If it still happens post a few more lines of code. I have seen errors like this returned telling you it's one line and in fact it is another. Phillip B wrote: > I tried wrapping it with Val() and Trim() and n

Re: queryparam problem

I tried wrapping it with Val() and Trim() and neither helped. I even tried this and I got the same error. Bryan F. Hogan wrote: > > cfsqltype="CF_SQL_TINYINT"> > > Phillip B wrote: > > > This is what I have > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [Use

Re: queryparam problem

cfsqltype="CF_SQL_TINYINT"> Phillip B wrote: > This is what I have > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: queryparam problem

This is what I have If I output attributes.boatline it displays 1. I have tried every thing I can think of but it is still a no go. Dave Francis wrote: > if you have quotes around '1', remove them >   -Original Message- > >   I'm trying to insert the number 1 into an int field in MSSQL

RE: queryparam problem

if you have quotes around '1', remove them   -Original Message-   From: Phillip B [mailto:[EMAIL PROTECTED]   Sent: Tuesday, May 18, 2004 12:18 PM   To: CF-Talk   Subject: queryparam problem   I'm trying to insert the number 1 into an int field in MSSQL 2000 but I   get a

queryparam problem

I'm trying to insert the number 1 into an int field in MSSQL 2000 but I get an "Invalid data for cfsqltype cf_sql_integer" error. I checked the table and it is an int 4 data type. Any idea why this would happen? Phillip B [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]