Re: This query was working in CF8 and now it will not work in CF9 on my server

2013-07-10 Thread Scott Stewart 

No problem, glad I could help
On Jul 9, 2013 8:35 PM, Terry Troxel terry.tro...@gmail.com wrote:


 That was it changed to desc1.

 Thank you very much.

 Terry


 On Tue, Jul 9, 2013 at 5:08 PM, Scott Stewart webmas...@sstwebworks.com
 wrote:

 
  A couple of things though Desc is a SQL reserved word. You may need
 to
  express the field name as [desc].  Second please wrap those variables in
  cfqueryparam tags.
  On Jul 9, 2013 8:05 PM, Scott Stewart webmas...@sstwebworks.com
 wrote:
 
   Nevermind... Damn text wrap on the phone.
   On Jul 9, 2013 8:04 PM, Scott Stewart webmas...@sstwebworks.com
  wrote:
  
   What's the *7 and the * at the end?
   On Jul 9, 2013 7:59 PM, Terry Troxel terry.tro...@gmail.com
 wrote:
  
  
Error Executing Database Query.  [Macromedia][SequeLink JDBC
   Driver][ODBC
   Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in
 INSERT
   INTO statement.The error occurred in
   *C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm:
   line 7*
  
   5 : cfquery name=addcat datasource=#dsn# maxrows=1
   6 : insert into cats(atitle,desc)*7 :
   values('#atitle#','#desc#')*
   8 : /cfquery
   9 : cfelseif x is update
  
--
  SQLSTATE   42000 SQLinsert into cats(atitle,desc)
  values('f','g')
   VENDORERRORCODE   -3502 DATASOURCE   libertree
  
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356153
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

This query was working in CF8 and now it will not work in CF9 on my server

2013-07-09 Thread Terry Troxel 

 Error Executing Database Query.  [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
INTO statement.The error occurred in
*C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm:
line 7*

5 : cfquery name=addcat datasource=#dsn# maxrows=1
6 : insert into cats(atitle,desc)*7 :   
values('#atitle#','#desc#')*
8 : /cfquery
9 : cfelseif x is update

 --
   SQLSTATE   42000 SQLinsert into cats(atitle,desc) values('f','g')
VENDORERRORCODE   -3502 DATASOURCE   libertree


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356145
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: This query was working in CF8 and now it will not work in CF9 on my server

2013-07-09 Thread Scott Stewart 

What's the *7 and the * at the end?
On Jul 9, 2013 7:59 PM, Terry Troxel terry.tro...@gmail.com wrote:


  Error Executing Database Query.  [Macromedia][SequeLink JDBC Driver][ODBC
 Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
 INTO statement.The error occurred in
 *C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm:
 line 7*

 5 : cfquery name=addcat datasource=#dsn# maxrows=1
 6 : insert into cats(atitle,desc)*7 :
 values('#atitle#','#desc#')*
 8 : /cfquery
 9 : cfelseif x is update

  --
SQLSTATE   42000 SQLinsert into cats(atitle,desc) values('f','g')
 VENDORERRORCODE   -3502 DATASOURCE   libertree


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356146
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: This query was working in CF8 and now it will not work in CF9 on my server

2013-07-09 Thread Scott Stewart 

Nevermind... Damn text wrap on the phone.
On Jul 9, 2013 8:04 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 What's the *7 and the * at the end?
 On Jul 9, 2013 7:59 PM, Terry Troxel terry.tro...@gmail.com wrote:


  Error Executing Database Query.  [Macromedia][SequeLink JDBC Driver][ODBC
 Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
 INTO statement.The error occurred in
 *C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm:
 line 7*

 5 : cfquery name=addcat datasource=#dsn# maxrows=1
 6 : insert into cats(atitle,desc)*7 :
 values('#atitle#','#desc#')*
 8 : /cfquery
 9 : cfelseif x is update

  --
SQLSTATE   42000 SQLinsert into cats(atitle,desc) values('f','g')
 VENDORERRORCODE   -3502 DATASOURCE   libertree


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356147
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: This query was working in CF8 and now it will not work in CF9 on my server

2013-07-09 Thread Scott Stewart 

A couple of things though Desc is a SQL reserved word. You may need to
express the field name as [desc].  Second please wrap those variables in
cfqueryparam tags.
On Jul 9, 2013 8:05 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 Nevermind... Damn text wrap on the phone.
 On Jul 9, 2013 8:04 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 What's the *7 and the * at the end?
 On Jul 9, 2013 7:59 PM, Terry Troxel terry.tro...@gmail.com wrote:


  Error Executing Database Query.  [Macromedia][SequeLink JDBC
 Driver][ODBC
 Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
 INTO statement.The error occurred in
 *C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm:
 line 7*

 5 : cfquery name=addcat datasource=#dsn# maxrows=1
 6 : insert into cats(atitle,desc)*7 :
 values('#atitle#','#desc#')*
 8 : /cfquery
 9 : cfelseif x is update

  --
SQLSTATE   42000 SQLinsert into cats(atitle,desc) values('f','g')
 VENDORERRORCODE   -3502 DATASOURCE   libertree


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356148
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: This query was working in CF8 and now it will not work in CF9 on my server

2013-07-09 Thread Terry Troxel 

That was it changed to desc1.

Thank you very much.

Terry


On Tue, Jul 9, 2013 at 5:08 PM, Scott Stewart webmas...@sstwebworks.comwrote:


 A couple of things though Desc is a SQL reserved word. You may need to
 express the field name as [desc].  Second please wrap those variables in
 cfqueryparam tags.
 On Jul 9, 2013 8:05 PM, Scott Stewart webmas...@sstwebworks.com wrote:

  Nevermind... Damn text wrap on the phone.
  On Jul 9, 2013 8:04 PM, Scott Stewart webmas...@sstwebworks.com
 wrote:
 
  What's the *7 and the * at the end?
  On Jul 9, 2013 7:59 PM, Terry Troxel terry.tro...@gmail.com wrote:
 
 
   Error Executing Database Query.  [Macromedia][SequeLink JDBC
  Driver][ODBC
  Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
  INTO statement.The error occurred in
  *C:\Inetpub\wwwroot\it-werks\LIBERTREE\index.cfm:
  line 7*
 
  5 : cfquery name=addcat datasource=#dsn# maxrows=1
  6 : insert into cats(atitle,desc)*7 :
  values('#atitle#','#desc#')*
  8 : /cfquery
  9 : cfelseif x is update
 
   --
 SQLSTATE   42000 SQLinsert into cats(atitle,desc)
 values('f','g')
  VENDORERRORCODE   -3502 DATASOURCE   libertree
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356150
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm