Thanx Mr.Dave
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 11, 2001 12:24 PM
Subject: RE: Xml from SQL 2k
Can any one tell me where can i find an article related to
xml with CF The database is sql server
, this problem is driving me mad!!!
Thanx Mr.Dave
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 11, 2001 12:24 PM
Subject: RE: Xml from SQL 2k
Can any one tell me where can i find an article related
http://www.houseoffusion.com/lists.cfm/link=m:4:17429:89212
-Original Message-
From: Andy Mcshane [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 18, 2004 12:19 PM
To: CF-Talk
Subject: Re: Xml from SQL 2k
I have been desperately searching for something similar to this. From my
Something strange is happening in my enterprise manager...
I have the box unchecked that shows system tables and stored procs, etc..
Yet when I go to the stored procs area I see all kinds of system stored
procs listed! None of the system tables are listed, but the procs are.
Any ideas?
[Todays
:51 PM
To: CF-Talk
Subject: OT: SQL 2K
Something strange is happening in my enterprise manager...
I have the box unchecked that shows system tables and stored procs, etc..
Yet when I go to the stored procs area I see all kinds of system stored
procs listed! None of the system tables are listed
I am using MS SQL Server 2K.
Wondering if there is an equivalent to the CF Len() function to get string length that
I can use in a WHERE clause:
SELECT LastName FROM Member WHERE Len(LastName) 5
---
Ben Morris
Web Site Developer
American Federation
does Len() not work in SQL 2K?
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2002 16:47
To: CF-Talk
Subject: Len() Equivalent in MS SQL 2K?
I am using MS SQL Server 2K.
Wondering if there is an equivalent to the CF Len() function to get string
length
Len() works pretty good for that :)
- Original Message -
From: BEN MORRIS [EMAIL PROTECTED]
Date: Wednesday, July 17, 2002 9:47 am
Subject: Len() Equivalent in MS SQL 2K?
I am using MS SQL Server 2K.
Wondering if there is an equivalent to the CF Len() function to
get string length
Subject: Len() Equivalent in MS SQL 2K?
I am using MS SQL Server 2K.
Wondering if there is an equivalent to the CF Len() function to get string
length that I can use in a WHERE clause:
SELECT LastName FROM Member WHERE Len(LastName) 5
---
Ben Morris
Ben,
actually, you can use LEN( ) exactly like that in an sql statement. Your
query should work.
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 10:47 AM
To: CF-Talk
Subject: Len() Equivalent in MS SQL 2K?
I am using MS SQL Server 2K
Just say
SELECT len(LastName) AS lastNameLen FROM Member WHERE Len(LastName) 5
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: BEN MORRIS [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 8:47 AM
Subject: Len() Equivalent in MS SQL 2K
It works in Access. In Oracle, the equivalent function is LENGTH().
WHERE LENGTH(imagefile) 0
does Len() not work in SQL 2K?
-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2002 16:47
To: CF-Talk
Subject: Len() Equivalent in MS SQL 2K?
I am using
I'm confused - I thought he was using SQL 2K??
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2002 16:59
To: CF-Talk
Subject: RE: Len() Equivalent in MS SQL 2K?
It works in Access. In Oracle, the equivalent function is LENGTH().
WHERE LENGTH(imagefile
He was, I was just answering a slightly different question and hoping to
provide some additional information. ;p
I'm confused - I thought he was using SQL 2K??
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2002 16:59
To: CF-Talk
Subject: RE: Len
[EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:47 AM
Subject: Len() Equivalent in MS SQL 2K?
I am using MS SQL Server 2K.
Wondering if there is an equivalent to the CF Len() function to get string
length that I can use in a WHERE clause:
SELECT LastName FROM Member WHERE Len(LastName) 5
17, 2002 7:45 PM
To: CF-Talk
Subject: Re: Len() Equivalent in MS SQL 2K?
I believe you're looking for the DataLength() function.
Respectfully,
Adam Phillip Churvis
Advanced Intensive ColdFusion MX Training
http://www.ColdFusionTraining.com
E-mail: [EMAIL PROTECTED]
Phone: 770-446-8866
:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 7:45 PM
To: CF-Talk
Subject: Re: Len() Equivalent in MS SQL 2K?
I believe you're looking for the DataLength() function.
Respectfully,
Adam Phillip Churvis
Advanced Intensive ColdFusion MX Training
http://www.ColdFusionTraining.com
E-mail
there was a function called DataLength in MS SQL 2K,
which explains why I enjoy reading your posts. (I did know about Len,
though.) However, after consulting BoL, it appears that this would return
the number of bytes rather than the number of characters; this sounds like
it could cause problems if you were
.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 1:32 PM
To: CF-Talk
Subject: CF Server / SQL 2K / IIS
Is it necessary for IIS to be running on the SQL Server if our webserver
is
a totally
Is it necessary for IIS to be running on the SQL Server if our webserver is
a totally separate machine?
No
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation ·
Nope.
- j
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 4:52 PM
To: CF-Talk
Subject: Re: CF Server / SQL 2K / IIS
Is it necessary for IIS to be running on the SQL Server if our webserver
is
a totally separate machine
, and
some poorly written CF to run the current app. Does anyone have any
experience using SQL 2K and CONNX together and then using CF to output the
data?
I suppose this more a SQL/CONNX post, but I am 22 and notice that most
people on this list are probably older than me and hope some might have
Does anyone have any experience using SQL 2K and CONNX together and
then using CF to output the data?
We are using CONNX to access DataFlex data with SQL7. We
can also set up an ODBC connection to the CONNX-connected
DataFlex data and access this via CF if needed. I don't know how
any idea why ' would kill the posting even when i have tried it both
with preservesinglespace
and without ;)
Thanks its a real pain in my arse
DBC Error Code = 37000 (Syntax error or access violation)
[MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark
before
the character
PROTECTED]
www.doceus.com
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 11:29 AM
To: CF-Talk
Subject: SQL 2k
any idea why ' would kill the posting even when i have tried it both
with preservesinglespace
and without ;)
Thanks its a real
-
From: Alex Santantonio [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, October 26, 2001 11:43 AM
Subject: RE: SQL 2k
Try a preserve single quote only on the value of the specific field
where
the single quote is contained, it looks like you are doing it on the
entire
SQL Query
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 12:17 PM
To: CF-Talk
Subject: Re: SQL 2k
nah just on the one i saw
but i see CFQUERYPARAM i hear might be promising
Bill Wheatley
Director of Development
Certified Advanced ColdFusion 5 Developer
AEPS INC
Allaire ColdFusion Consulting
27 matches
Mail list logo