RE: chars not accepted in SQL?

> > INSERT INTO > > itemsordered > > (item) > > VALUES > > (' > > cfsqltype="CF_SQL_CHAR">') > > > > It still gives a incorrect syntax error. > > > > How do I correctly incorporate that into the above insert? > > Get rid of the apostrophies, you don't need them - see our examples Shouldn't y

RE: chars not accepted in SQL?

No need for ' with cfqueryparam: VALUES ( cfsqltype="CF_SQL_CHAR">) > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: vrijdag 11 juni 2004 16:23 > To: CF-Talk > Subject: RE: chars not accepted in SQL? > > Thanks.

RE: chars not accepted in SQL?

Thanks all. I'm slowlly...getting the hang of everything. -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 10:21 AM To: CF-Talk Subject: Re: chars not accepted in SQL? On Fri, 11 Jun 2004 10:07:15 -0400, Robert Orlini wrote: > >

Re: chars not accepted in SQL?

On Fri, 11 Jun 2004 10:22:57 -0400, Robert Orlini wrote: > > I have it down as: > > > INSERT INTO itemsordered > (item) > VALUES > ('') > > > It still gives a incorrect syntax error. > > How do I correctly incorporate that into the above insert? Get rid of the apostrophies, you don't need th

RE: chars not accepted in SQL?

2004 10:17 AM To: CF-Talk Subject: Re: chars not accepted in SQL? On Friday 11 Jun 2004 15:07 pm, Robert Orlini wrote: > CFQUERYPARAM go into the Insert? The sample code I got below confused me. In most cases instead of dbFieldName=#thing# you write dbFieldName= (If the query is in a loop,)

RE: chars not accepted in SQL?

INSERT INTO tbl(col) VALUES() Whenever you have a value, use with the appropriate cfsqltype Pascal > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: vrijdag 11 juni 2004 16:07 > To: CF-Talk > Subject: RE: chars not accepted in SQL? > >

Re: chars not accepted in SQL?

On Fri, 11 Jun 2004 10:07:15 -0400, Robert Orlini wrote: > > I have an apostrophe in the input filed before I submit yes. How does this CFQUERYPARAM go into the Insert? The sample code I got below confused me. Sorry folks I'm a newbie at this, but I'm doing my best to try. insert into table (fiel

Re: chars not accepted in SQL?

On Friday 11 Jun 2004 15:07 pm, Robert Orlini wrote: > CFQUERYPARAM go into the Insert? The sample code I got below confused me. In most cases instead of dbFieldName=#thing# you write dbFieldName= (If the query is in a loop,) it'll execute much faster too. -- Tom Chiverton Advanced ColdFusion

RE: chars not accepted in SQL?

-Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 9:52 AM To: CF-Talk Subject: Re: chars not accepted in SQL? On Fri, 11 Jun 2004 09:36:26 -0400, Robert Orlini wrote: > > I get this error when I click SUBMIT in a form where I have an a

RE: chars not accepted in SQL?

Use !! > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: vrijdag 11 juni 2004 15:36 > To: CF-Talk > Subject: chars not accepted in SQL? > > I get this error when I click SUBMIT in a fo

Re: chars not accepted in SQL?

On Fri, 11 Jun 2004 09:36:26 -0400, Robert Orlini wrote: > > I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as "John's" in the input field: > > ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]Lin

chars not accepted in SQL?

I get this error when I click SUBMIT in a form where I have an apostrophe in a name such as "John's" in the input field: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax near 's'. SQL = "INSERT INTO itemsordered Is