Bryan,
MS-SQL = Microsoft SQL Server. Am not sure if Microsoft Access uses T-SQL.
Last time i looked at Access, it would let you use "Double Quotes".
Microsoft SQL-Server (Havent looked at Oracle, am sure it can be done)
You Can force T-SQL or SQL-92 Standard with SET QUOTED_IDENTIFIER ON|OFF,
so basically you can use Single OR Double quotes, but Quotes are Required.
Example
SET QUOTED_IDENTIFIER ON
Insert into MyTable(Field) values('SomeData')
OR
SET QUOTED_IDENTIFIER OFF
Insert into MyTable(Field) values("SomeData")
Both of the above work, One using T-SQL and the other using SQL-92.
Joe Eugene
> -----Original Message-----
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 6:38 PM
> To: CF-Talk
> Subject: Re: Learned something today (Oracle)
>
>
> Hey Joe...what's MS-SQL?? Access and SQL Server both use T-SQL or is
> the"MS" throwing me?
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
>
> ---------------------------------------------------------
> Macromedia Associate Partner
> www.macromedia.com
> ---------------------------------------------------------
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> ----- Original Message -----
> From: "Joe Eugene" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 02, 2003 3:27 PM
> Subject: RE: Learned something today (Oracle)
>
>
> > > They must be single-quotes. (guess you weren't paying attn in
> SQL 101 ;)
> > > J/K of course.
> >
> > I dont think i mentioned Oracle or any DB for that matter :)
> > Different DB's have variations in SQL.. T-SQL for MS-SQL , PL-SQL for
> Oracle
> > etc.
> > Access you can use double quotes...
> > > > All String(char/varchar) fields in the query should have
> single/double
> > > > quotes.
> > Perhaps you didnt read "single/double" :)
> >
> >
> > Joe Eugene
> >
> >
> > > -----Original Message-----
> > > From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, April 02, 2003 6:15 PM
> > > To: CF-Talk
> > > Subject: RE: Learned something today (Oracle)
> > >
> > >
> > >
> > > > All String(char/varchar) fields in the query should have
> single/double
> > > > quotes.
> > > > This is something you learn in SQL 101.
> > >
> > >
> > > To clarify- in Oracle if you put double-quotes around a value that
> you're
> > > matching to a String field (char/varchar), it'll come back with an
> error.
> > > They must be single-quotes. (guess you weren't paying attn in
> SQL 101 ;)
> > > J/K of course.
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
