Using Cursor in MS SQL 7.0
Hi, I have wrote a stored proc which creates a cursor, I then open it, loop within it, append the id to a variable and when finished close it and print out the variable. I am testing the PROC inside Query Analyzer. The first time it runs ok, but the second time it wont, this is the PROC, CREATE PROCEDURE LEO4_CURRENT_STATES_WITH_LOCATION (@CUSTOMERID INT) AS DECLARE @STR_IDS VARCHAR(500) SET @STR_IDS='' DECLARE CUR_CUSTOMER_V_IDS INSENSITIVE CURSOR FOR SELECT DISTINCT TABLE.VEHICLEID FROM TABLE WHERE [EMAIL PROTECTED] OPEN CUR_CUSTOMER_V_IDS DECLARE @CURRID INT WHILE @@FETCH_STATUS -1 BEGIN FETCH NEXT FROM CUR_CUSTOMER_V_IDS INTO @CURRID IF @STR_IDS = '' BEGIN SET @STR_IDS=CAST(@CURRID AS VARCHAR(4)) END ELSE BEGIN SET @[EMAIL PROTECTED]','+CAST(@CURRID AS VARCHAR(4)) END END CLOSE CUR_CUSTOMER_V_IDS DEALLOCATE CUR_CUSTOMER_V_IDS PRINT 'START' PRINT @STR_IDS PRINT 'END' first time it runs the out put looks something like this where x is an ID digit, START xxx,xxx,xxx,xx,,xxx END the second time I run it I get this, START END I'm not sure whats happening here, I have closed the cursor and removed it from memory. The only way I can get it to run again is to close down my database session window in query anaylzer and reconnect. I have only done testing in QA not from CF, but I would imagine the same thing would be happening. Would anyone have any ideas. J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Using Cursor in MS SQL 7.0
You might want to change your WHILE condition to this: WHILE (@@FETCH_STATUS=0) -- Here are the codes from Microsoft's site at http://msdn.microsoft.com/library/default.asp?url=""> : @@FETCH_STATUS Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection. Return value Description 0 FETCH statement was successful. -1 FETCH statement failed or the row was beyond the result set. -2 Row fetched is missing. -- Have you tried putting a FETCH statement before the WHILE and move the FETCH inside the WHILE to the end of the loop?Something like this: FETCH NEXT FROM CUR_CUSTOMER_V_IDS INTO @CURRID WHILE (@@FETCH_STATUS=0) BEGIN IF @STR_IDS = '' BEGIN SET @STR_IDS=CAST(@CURRID AS VARCHAR(4)) END ELSE BEGIN SET @[EMAIL PROTECTED]','+CAST(@CURRID AS VARCHAR(4)) END FETCH NEXT FROM CUR_CUSTOMER_V_IDS INTO @CURRID END Tom Nunamaker Hi, I have wrote a stored proc which creates a cursor, I then open it, loop within it, append the id to a variable and when finished close it and print out the variable. I am testing the PROC inside Query Analyzer. The first time it runs ok, but the second time it wont, this is the PROC, CREATE PROCEDURE LEO4_CURRENT_STATES_WITH_LOCATION (@CUSTOMERID INT) AS DECLARE @STR_IDS VARCHAR(500) SET @STR_IDS='' DECLARE CUR_CUSTOMER_V_IDS INSENSITIVE CURSOR FOR SELECT DISTINCT TABLE.VEHICLEID FROM TABLE WHERE [EMAIL PROTECTED] OPEN CUR_CUSTOMER_V_IDS DECLARE @CURRID INT WHILE @@FETCH_STATUS -1 BEGIN FETCH NEXT FROM CUR_CUSTOMER_V_IDS INTO @CURRID IF @STR_IDS = '' BEGIN SET @STR_IDS=CAST(@CURRID AS VARCHAR(4)) END ELSE BEGIN SET @[EMAIL PROTECTED]','+CAST(@CURRID AS VARCHAR(4)) END END CLOSE CUR_CUSTOMER_V_IDS DEALLOCATE CUR_CUSTOMER_V_IDS PRINT 'START' PRINT @STR_IDS PRINT 'END' first time it runs the out put looks something like this where x is an ID digit, START xxx,xxx,xxx,xx,,xxx END the second time I run it I get this, START END I'm not sure whats happening here, I have closed the cursor and removed it from memory. The only way I can get it to run again is to close down my database session window in query anaylzer and reconnect. I have only done testing in QA not from CF, but I would imagine the same thing would be happening. Would anyone have any ideas. J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Error inserting into SQL 7.0 server
Below is the text output of what i am trying to insert into a table in a sql
7.0 server.
I have pasted the text into sql window of sql enterprise manager and it
checked ok. But still gives me an odbc error.
Any suggestions?
INSERT INTO tbl_upload_content
(UploadFilename,HyperLinkTitle,Description)
Values
('CF_Print_zip','This is a test','Test of hyperlink and doc')
H4Error Diagnostic Information/H4
PODBC Error Code = 37000 (Syntax error or access violation)
P
P[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax
near
'CF_Print_zip'.
P
P
PThe error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (63:1) to (63:47)./P
P
PDate/Time: 01/17/02 10:01:44BRBrowser: Mozilla/4.0 (compatible; MSIE
6.0;
Windows NT 5.1; Q312461)BRRemote Address: 127.0.0.1BRHTTP Referer:
http://localhost/autoupload/upload.cfm/P
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error inserting into SQL 7.0 server
Are you sure that CF's ODBC setup has the exact same permissions as you used
in registering your server in SQL enterprise manager?
Mark
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 7:05 AM
To: CF-Talk
Subject: Error inserting into SQL 7.0 server
Below is the text output of what i am trying to insert into a table in a sql
7.0 server.
I have pasted the text into sql window of sql enterprise manager and it
checked ok. But still gives me an odbc error.
Any suggestions?
INSERT INTO tbl_upload_content
(UploadFilename,HyperLinkTitle,Description)
Values
('CF_Print_zip','This is a test','Test of hyperlink and doc')
H4Error Diagnostic Information/H4
PODBC Error Code = 37000 (Syntax error or access violation)
P
P[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax
near
'CF_Print_zip'.
P
P
PThe error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (63:1) to (63:47)./P
P
PDate/Time: 01/17/02 10:01:44BRBrowser: Mozilla/4.0 (compatible; MSIE
6.0;
Windows NT 5.1; Q312461)BRRemote Address: 127.0.0.1BRHTTP Referer:
http://localhost/autoupload/upload.cfm/P
_
_
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB
MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error inserting into SQL 7.0 server
I am using SA on the cf dsn.
- Original Message -
From: Mark A. Kruger - CFG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 12:29 PM
Subject: RE: Error inserting into SQL 7.0 server
Are you sure that CF's ODBC setup has the exact same permissions as you
used
in registering your server in SQL enterprise manager?
Mark
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 7:05 AM
To: CF-Talk
Subject: Error inserting into SQL 7.0 server
Below is the text output of what i am trying to insert into a table in a
sql
7.0 server.
I have pasted the text into sql window of sql enterprise manager and it
checked ok. But still gives me an odbc error.
Any suggestions?
INSERT INTO tbl_upload_content
(UploadFilename,HyperLinkTitle,Description)
Values
('CF_Print_zip','This is a test','Test of hyperlink and doc')
H4Error Diagnostic Information/H4
PODBC Error Code = 37000 (Syntax error or access violation)
P
P[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax
near
'CF_Print_zip'.
P
P
PThe error occurred while processing an element with a general
identifier
of
(CFQUERY), occupying document position (63:1) to (63:47)./P
P
PDate/Time: 01/17/02 10:01:44BRBrowser: Mozilla/4.0 (compatible; MSIE
6.0;
Windows NT 5.1; Q312461)BRRemote Address: 127.0.0.1BRHTTP Referer:
http://localhost/autoupload/upload.cfm/P
_
_
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB
MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error inserting into SQL 7.0 server
Have you tried running the query in Query Analyzer? Does it run there?
Mike
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 10:42 AM
To: CF-Talk
Subject: Re: Error inserting into SQL 7.0 server
I am using SA on the cf dsn.
- Original Message -
From: Mark A. Kruger - CFG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 12:29 PM
Subject: RE: Error inserting into SQL 7.0 server
Are you sure that CF's ODBC setup has the exact same permissions as
you
used
in registering your server in SQL enterprise manager?
Mark
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 7:05 AM
To: CF-Talk
Subject: Error inserting into SQL 7.0 server
Below is the text output of what i am trying to insert into a table
in a
sql
7.0 server.
I have pasted the text into sql window of sql enterprise manager and
it
checked ok. But still gives me an odbc error.
Any suggestions?
INSERT INTO tbl_upload_content
(UploadFilename,HyperLinkTitle,Description)
Values
('CF_Print_zip','This is a test','Test of hyperlink and doc')
H4Error Diagnostic Information/H4
PODBC Error Code = 37000 (Syntax error or access violation)
P
P[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect
syntax
near
'CF_Print_zip'.
P
P
PThe error occurred while processing an element with a general
identifier
of
(CFQUERY), occupying document position (63:1) to (63:47)./P
P
PDate/Time: 01/17/02 10:01:44BRBrowser: Mozilla/4.0 (compatible;
MSIE
6.0;
Windows NT 5.1; Q312461)BRRemote Address: 127.0.0.1BRHTTP
Referer:
http://localhost/autoupload/upload.cfm/P
_
_
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20
GB
MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error inserting into SQL 7.0 server
Yes, it runs there fine. I even tried cfoutput to see what the sql is
when it is used in cfquery and copied it from the browser and pasted it back
into another cfquery tag with the static sql statment. it works fine.
This is what is happening. I have a form page with the form fields names
the same as what is in my table. I then use an include page that builds the
sql statement for me.
here is the insert page.
!--- Int Fields with default ---
cfparam name=FieldNameValue default=
cfparam name=ColumnNames default=
cfparam name=FieldNameValues default=
!--- Get Column Names, Data Types from Form Field TableName and DSN(should
be an hidden form fields ---
cfquery name=GetTableInfodatasource=#Form.DSN#
sp_columns #Form.TableName#
/cfquery
!--- Loop through each column in table ---
cfloop query=GetTableInfo
cfif ListFindNoCase(Form.FIELDNAMES,Column_Name) NEQ 0 AND
Trim(Evaluate(ListGetAt(Form.FieldNames,ListFindNoCase(Form.FIELDNAMES,Colum
n_Name NEQ
cfset ElePos = ListFindNoCase(Form.FIELDNAMES,Column_Name)
!--- Check to see what data type each column is and build insert based on
value ---
CFSWITCH EXPRESSION=#GetTableInfo.Type_Name#
cfcase value=varchar
cfset FieldNameValues = FieldNameValues , '
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) '
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=datetime
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=text
cfset FieldNameValues = FieldNameValues , '
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos))) '
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=timestamp
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
cfcase value=smalldatetime
cfset FieldNameValues = FieldNameValues ,
CreateODBCDateTime(Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos
cfset ColumnNames = ColumnNames , Column_Name
/cfcase
CFDEFAULTCASE
cfset FieldNameValues = FieldNameValues ,
Trim(Evaluate(ListGetAt(Form.FieldNames,ElePos)))
cfset ColumnNames = ColumnNames , Column_Name
/CFDEFAULTCASE
/CFSWITCH
/cfif
/cfloop
!--- Check to see if there is a ,(comma) at the END the string ---
CFIF Left(FieldNameValues,1) EQ ,cfset FieldNameValues =
Right(FieldNameValues,Len(FieldNameValues)-1)/CFIF
CFIF Left(ColumnNames,1) EQ ,cfset ColumnNames =
Right(ColumnNames,Len(ColumnNames)-1)/CFIF
!--- Sample Insert statement ---
cfoutput
INSERT INTO #Form.Tablename#
(#Trim(ColumnNames)#)
VALUES (#Trim(FieldNameValues)#)
/cfoutput
cfquery name=Insert datasource=#Form.DSN#
INSERT INTO #Form.Tablename#
(#Trim(ColumnNames)#)
VALUES (#Trim(FieldNameValues)#)
/cfquery
As you can see it should work, but it does not.
- Original Message -
From: Haggerty, Michael A. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 11:34 AM
Subject: RE: Error inserting into SQL 7.0 server
Have you tried running the query in Query Analyzer? Does it run there?
Mike
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 10:42 AM
To: CF-Talk
Subject: Re: Error inserting into SQL 7.0 server
I am using SA on the cf dsn.
- Original Message -
From: Mark A. Kruger - CFG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 12:29 PM
Subject: RE: Error inserting into SQL 7.0 server
Are you sure that CF's ODBC setup has the exact same permissions as
you
used
in registering your server in SQL enterprise manager?
Mark
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 7:05 AM
To: CF-Talk
Subject: Error inserting into SQL 7.0 server
Below is the text output of what i am trying to insert into a table
in a
sql
7.0 server.
I have pasted the text into sql window of sql enterprise manager and
it
checked ok. But still gives me an odbc error.
Any suggestions?
INSERT INTO tbl_upload_content
(UploadFilename,HyperLinkTitle,Description)
Values
('CF_Print_zip','This is a test','Test of hyperlink and doc')
H4Error Diagnostic Information/H4
PODBC Error Code = 37000 (Syntax error or access violation)
P
P[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect
syntax
near
'CF_Print_zip'.
P
P
PThe error occurred while processing an element with a general
identifier
of
(CFQUERY), occupying document position (63:1) to (63:47)./P
P
PDate/Time: 01/17/02 10:01:44BRBrowser: Mozilla/4.0 (compatible;
MSIE
6.0;
Windows NT 5.1; Q312461)BRRemote Address: 127.0.0.1BRHTTP
Referer:
http://localhost/autoupload/upload.cfm/P
SQL 7.0 linking Tables to Access
Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cancel: SQL 7.0 linking Tables to Access
Sorted! -Original Message- From: Jerry Staple Sent: 29 July 2001 07:57 To: CF-Talk Subject: SQL 7.0 linking Tables to Access Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cancel: SQL 7.0 linking Tables to Access
I am not sure about 7 but in 2000 you can link to a server of a different type like Access. This is from help file: HTH The Microsoft® OLE DB Provider for Jet provides an OLE DB interface to Microsoft Access databases, and allows Microsoft SQL ServerT 2000 distributed queries to query Access databases. To create a linked server to access an Access database 1.. Execute sp_addlinkedserver to create the linked server, specifying Microsoft.Jet.OLEDB.4.0 as provider_name, and the full path name of the Access .mdb database file as data_source. The .mdb database file must reside on the server. data_source is evaluated on the server, not the client, and the path must be valid on the server. For example, to create a linked server named Nwind that operates against the Access database named Nwind.mdb in the C:\Mydata directory, execute: sp_addlinkedserver 'Nwind', 'Access 97', 'Microsoft.Jet.OLEDB.4.0', 'c:\mydata\Nwind.mdb' 2.. To access an unsecured Access database, SQL Server logins attempting to access an Access database should have a login mapping defined to the username Admin with no password. This example enables access for the local user Joe to the linked server named Nwind. sp_addlinkedsrvlogin 'Nwind', false, 'Joe', 'Admin', NULL To access a secured Access database, configure the registry (using the Registry Editor) to use the correct Workgroup Information file used by Access. Use the Registry Editor to add the full path name of the Workgroup Information file used by Access to this registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\SystemDB After the registry entry is configured, use sp_addlinkedsrvlogin to create login mappings from local logins to Access logins: sp_addlinkedsrvlogin 'Nwind', false, 'Joe', 'AccessUser', 'AccessPwd' Access databases do not have catalog and schema names. Therefore, tables in an Access-based linked server can be referenced in distributed queries using a four-part name of the form linked_server...table_name. This example retrieves all rows from the Employees table in the linked server named Nwind. SELECT * FROM Nwind...Employees - Original Message - From: Jerry Staple [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 29, 2001 1:21 AM Subject: Cancel: SQL 7.0 linking Tables to Access Sorted! -Original Message- From: Jerry Staple Sent: 29 July 2001 07:57 To: CF-Talk Subject: SQL 7.0 linking Tables to Access Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: nvarchar vs varchar (was SQL 7.0 )
On Sat, 28 Jul 2001 04:24:31 +1000, Mike Kear [EMAIL PROTECTED] wrote: I'm really interested in this because I've had no end of problems when I upsize an access table and SQL7 sets the fields to nvarchar or ntext. I have to go in and manually change them to varchar and text. Yet other people say they have no problem with ntext and nvarchar. Can anyone else help pin down what's going on here?If there's a CF setting to make or a SQL7 setting to make to get rid of this issue I'm all ears! I think it has a lot to do with the version of CF that you are using. WebCentral in Aus for example are still stuck in the dark ages with CF 4.0 (not even 4.0.1) so I had problems with a client hosted there. I don't think that CF 4.5 has these problems. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 7.0 linking to Access
Hi Can any one inform me of a way to link from a SQL Db to an access db table?The access table in future will be transfered to SQL 7,but not yet. I know about the import etc but i would like the SQL database to be linked to a live Access Table. Any Ideas?? Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 7.0
What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Try ntext -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 4:28 PM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
text Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
ntext but I prefer to use varchar(8000) -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 16:28 To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
text (or ntext if you need unicode support) -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 16:28 To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
I need something bigger than 8000, more like double this... I have tried all these!! -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:46 AM To: CF-Talk Subject: RE: SQL 7.0 ntext but I prefer to use varchar(8000) -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 16:28 To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier to use text, varchar and the like rather than their N equivalents... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
I have this now and there is a field of text I need to place into this field and it complains that the size is to small!!! -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 2:02 AM To: CF-Talk Subject: RE: SQL 7.0 I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
ntext but I prefer to use varchar(8000) 2 problems with this 1) You're limiting the user to 8,000 characters - if it's a HTML page, then it can break this easily 2) SQL 7 has a row limit of just over 8Kb - you can only use this and 1 or 2 other fields before you start getting errors I'd stick to text... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
HOW BIG IS IT?! text = 2,147,483,647 chars ntext = 1,073,741,823 chars I could store the contents * 10 of my SQL Server 7.0 book in that field. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 5:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
What are you storing? Text will hold up to up to 2GB of data. Duane -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Just how big do you need to go? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
If this is the case then you will need to chop up your text and insert it into multiple rows in the database. I had to do this once to make legal documents insert into an Access database(Client insisted on Access)... It was a pain but it did the job.. HTH Clint -- Original Message -- from: Andrew Scott [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sat, 28 Jul 2001 02:29:22 +1000 I have this now and there is a field of text I need to place into this field and it complains that the size is to small!!! -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 2:02 AM To: CF-Talk Subject: RE: SQL 7.0 I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Sorry I need something bigger than both of these ntext and text provide!! You may want to try again. A text datatype can hold as much as 2,147,483,647 bytes of data. I don't know what an Access memo field can hold, but I'm sure it isn't as big as that. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Sorry I need something bigger than both of these ntext and text provide!! It would be surprising if you really needed to store more than 2,147,483,647 characters, which is the maximum length of an SQL 7 text column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Text will hold something like 2 gigabytes (i don't have the docs in front of me)... If that's not big enough, storing it in SQL probably isn't a good idea. Try storing it in a file and storing the filename in SQL. As a side note... http://terraserver.microsoft.com stores satellite images of most of the US. All the images are stored as BLOBs in a SQL Server cluster. Norman Quoting Andrew Scott [EMAIL PROTECTED]: I need something bigger than 8000, more like double this... I have tried all these!! -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:46 AM To: CF-Talk Subject: RE: SQL 7.0 ntext but I prefer to use varchar(8000) -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 16:28 To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
from BOL: text Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. You really need more than 2GB of data??? in one text field??? WOW... -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 17:05 To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Memo fields in Access hold 64k maximum I do believe. -paris -Original Message- From: Benjamin S. Rogers [EMAIL PROTECTED] Date: Fri, 27 Jul 2001 12:46:52 -0400 Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! You may want to try again. A text datatype can hold as much as 2,147,483,647 bytes of data. I don't know what an Access memo field can hold, but I'm sure it isn't as big as that. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Andrew, NTEXT provides for a farily large amount of data (for example, an entire resume). If you want something bigger than what SQL can handle, you should just use CFFILE to create text files to store the data. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:05 AM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:10 AM To: CF-Talk Subject: RE: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier to use text, varchar and the like rather than their N equivalents... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Have you counted the characters of whatever text it is you're trying to insert into the SQL field? And can you insert this same text into Access, but not a SQL ntext field? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:29 AM To: CF-Talk Subject: RE: SQL 7.0 I have this now and there is a field of text I need to place into this field and it complains that the size is to small!!! -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 2:02 AM To: CF-Talk Subject: RE: SQL 7.0 I believe that's NTEXT (16). You can verify that by exporting an Access database with a memo field into SQL. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:28 AM To: CF-Talk Subject: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
The difference between NTEXT and TEXT is that NTEXT supports Unicode data. The price for this is that it takes twice as much space on your server to store NTEXT data as it does to store TEXT data. Consequently, SQL Server will only let you store half as much NTEXT data as TEXT data. ColdFusion does not understand Unicode data as such so you cannot manipulate Unicode data. Therefore, if you are working in a ColdFusion environment, you generally gain no benefit using the NTEXT datatype as oposed to the TEXT datatype. So, it is not that NTEXT is incompatible, but rather, an unnecessary use of system resources. There are always exceptions, of course. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 1:10 PM To: CF-Talk Subject: RE: SQL 7.0 How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:10 AM To: CF-Talk Subject: RE: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier to use text, varchar and the like rather than their N equivalents... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
nvarchar vs varchar (was SQL 7.0 )
I'm really interested in this because I've had no end of problems when I upsize an access table and SQL7 sets the fields to nvarchar or ntext. I have to go in and manually change them to varchar and text. Yet other people say they have no problem with ntext and nvarchar. Can anyone else help pin down what's going on here?If there's a CF setting to make or a SQL7 setting to make to get rid of this issue I'm all ears! Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Subject: RE: SQL 7.0 How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Subject: RE: SQL 7.0 ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0
ColdFusion does not understand Unicode data as such so you cannot manipulate Unicode data. Therefore, if you are working in a ColdFusion environment, you once again, not to start a war, but cf unicode get along just fine. depending on the encoding language you can even come darned close to parsing unicode strings and you can certainly use clientside js w/cf for that where cf can't pull its load. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
I appreciate the explanation. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:22 AM To: CF-Talk Subject: RE: SQL 7.0 The difference between NTEXT and TEXT is that NTEXT supports Unicode data. The price for this is that it takes twice as much space on your server to store NTEXT data as it does to store TEXT data. Consequently, SQL Server will only let you store half as much NTEXT data as TEXT data. ColdFusion does not understand Unicode data as such so you cannot manipulate Unicode data. Therefore, if you are working in a ColdFusion environment, you generally gain no benefit using the NTEXT datatype as oposed to the TEXT datatype. So, it is not that NTEXT is incompatible, but rather, an unnecessary use of system resources. There are always exceptions, of course. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 1:10 PM To: CF-Talk Subject: RE: SQL 7.0 How is that field type incompatible with ColdFusion? I use it and it seems to be working fine. Am I missing something here? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 9:10 AM To: CF-Talk Subject: RE: SQL 7.0 What is the equivalent to memo in ms SQL 7.0, for the life of me my mind has gone to the fairies on this one! Try ntext ntext is UNICODE, and since CF45 aren't UNICODE compatible, this won't do anything for you apart from eat twice the hard disk space Until CF6/Neo comes out, it's easier to use text, varchar and the like rather than their N equivalents... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
I'm dying to know how you figure that out... Something tells me I should probably know. At 01:14 PM 07/27/2001 -0400, you wrote: Sorry I need something bigger than both of these ntext and text provide!! It would be surprising if you really needed to store more than 2,147,483,647 characters, which is the maximum length of an SQL 7 text column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
I'm dying to know how you figure that out... Something tells me I should probably know. There's no magic involved. Here's how I did it. 1. Open SQL Server Books Online. 2. Search for text. 3. Copy field length into email message. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
you're kidding! it's THAT easy??? ;-) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:34 PM To: CF-Talk Subject: RE: SQL 7.0 I'm dying to know how you figure that out... Something tells me I should probably know. There's no magic involved. Here's how I did it. 1. Open SQL Server Books Online. 2. Search for text. 3. Copy field length into email message. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Wait sec. Which website are the books online at? lol ; ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:34 PM To: CF-Talk Subject: RE: SQL 7.0 you're kidding! it's THAT easy??? ;-) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:34 PM To: CF-Talk Subject: RE: SQL 7.0 I'm dying to know how you figure that out... Something tells me I should probably know. There's no magic involved. Here's how I did it. 1. Open SQL Server Books Online. 2. Search for text. 3. Copy field length into email message. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another clustering question (MS SQL 7.0).
Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another clustering question (MS SQL 7.0).
Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB and 2 SQL servers. One of the SQL servers is live and the other is passive, both sharing a disk array containing the databases. If server 1 fails then server 2 takes over. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:29 To: CF-Talk Subject: Another clustering question (MS SQL 7.0). Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Another clustering question (MS SQL 7.0).
Thank you, Andrew! please tell me, can Co-Standby control IIS and ColdFusion services? Alexandr. AE Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB AE and 2 SQL servers. One of the SQL servers is live and the other is passive, AE both sharing a disk array containing the databases. If server 1 fails then AE server 2 takes over. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Another clustering question (MS SQL 7.0).
Don't think so..I think it only controls SQL services. I have not set one up myself. Our ISP set the cluser up for us and just tell us what each bit does. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:43 To: CF-Talk Subject: Re[2]: Another clustering question (MS SQL 7.0). Thank you, Andrew! please tell me, can Co-Standby control IIS and ColdFusion services? Alexandr. AE Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB AE and 2 SQL servers. One of the SQL servers is live and the other is passive, AE both sharing a disk array containing the databases. If server 1 fails then AE server 2 takes over. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another clustering question (MS SQL 7.0).
Distributed Partitioned Views are real the only way 2 load balance in MS SQL but u will need MS SQL 2000 Enterprise Edition. From Rif Kiamil -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:32 To: CF-Talk Subject:RE: Another clustering question (MS SQL 7.0). Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB and 2 SQL servers. One of the SQL servers is live and the other is passive, both sharing a disk array containing the databases. If server 1 fails then server 2 takes over. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:29 To: CF-Talk Subject: Another clustering question (MS SQL 7.0). Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 (checking for the existence of a table)
IF EXISTS (SELECT * FROM sysobjects WHERE name = tablename AND type = P) BEGIN Table exisits! END ELSE BEGIN table doesn't exist END -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 23:47 To: CF-Talk Subject: SQL 7.0 (checking for the existence of a table) Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help. Brook Davies MaracasMedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 (checking for the existence of a table)
Sorry ...ignoree my last postthat was to test for the existence of an SP!replace type=P with type=U for a user table or type=S for a system table -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 10:11 To: CF-Talk Subject: RE: SQL 7.0 (checking for the existence of a table) IF EXISTS (SELECT * FROM sysobjects WHERE name = tablename AND type = P) BEGIN Table exisits! END ELSE BEGIN table doesn't exist END -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 13 May 2001 23:47 To: CF-Talk Subject: SQL 7.0 (checking for the existence of a table) Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help. Brook Davies MaracasMedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 7.0 (checking for the existence of a table)
Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help. Brook Davies MaracasMedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 (checking for the existence of a table)
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ANDTABLE_NAME = '#SOME_TABLE_NAME#' HTH P. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 6:47 PM To: CF-Talk Subject: SQL 7.0 (checking for the existence of a table) Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help. Brook Davies MaracasMedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 7.0 Single User Mode
Does any one know why a SQL 7.0 database would continually go into single user mode? Brook Davies Maracasmedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Single User Mode
I was having this problem also and someone on a newsgroup said it might have something to do with having a maintenance plan that is trying to fix small problems (don't remember the exact terminology used with the maintenance plan but it's like the second or third window). I unchecked that option and never had the problem again. I also heard that it is a bug that was fixed in sp3. Do you have that installed? I didn't at the time but now do. Good luck! Derek - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 10:57 AM Subject: SQL 7.0 Single User Mode Does any one know why a SQL 7.0 database would continually go into single user mode? Brook Davies Maracasmedia Inc. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql 7.0 vs. sql 2000
sql 7.0 vs. sql 2000 What are the advantage and disadvantages? Thanks Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7.0 vs. sql 2000
SQL Server has 3 advantages to SQL Server 7 1) Functions (A true lifesaver) 2) XML Support (Both into and out of the database) 3) Stability (although I have never had any problems with 7's stability) -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 1:21 PM To: CF-Talk Subject: sql 7.0 vs. sql 2000 sql 7.0 vs. sql 2000 What are the advantage and disadvantages? Thanks Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7.0 vs. sql 2000
Although it's not a major reason to upgrade, the client tools that come with SS2K contain some nice enhancements. If you're building complex stored procedures, Query Analyzer's built in SP debugger is an excellent tool. One thing to keep in mind - I've heard from a number of reliable sources that SS7 performs better on NT than SS2K. So if you're on NT, you may want to stick with SS7, but if you're on or moving to W2K, you'll get a performance boost from SS2K. Bob -Original Message- From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]] Sent: April 9, 2001 1:26 PM To: CF-Talk Subject: RE: sql 7.0 vs. sql 2000 SQL Server has 3 advantages to SQL Server 7 1) Functions (A true lifesaver) 2) XML Support (Both into and out of the database) 3) Stability (although I have never had any problems with 7's stability) -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 1:21 PM To: CF-Talk Subject: sql 7.0 vs. sql 2000 sql 7.0 vs. sql 2000 What are the advantage and disadvantages? Thanks Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion access to a DSN-less SQL 7.0 =
It is possible, as long as you have a dsn on the system pointing to a SQL 7.0 ds - then access tables etc. as #dbname#.dbo.#tablename# HTH Dan -Original Message- From: Winston Sia [mailto:[EMAIL PROTECTED]] Sent: 01 March 2001 02:51 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: This is a multi-part message in MIME format. --=_NextPart_000_003A_01C0A23D.8EED6040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI, Is it possible for Coldfusion to have access to a DSN-less SQL 7.0 = database? This DSN-less database is being used by our ASP templates. Now, we want = to use our CF templates to be able to access this same database.. Any = idea? Our webhost is Hostcentric (Virtualscape) so we would be asking them to = do for us what your recommendations will be.. TIA. Winston --=_NextPart_000_003A_01C0A23D.8EED6040 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArialHI,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialIs it possible for Coldfusion to have access to = a DSN-less=20 SQL 7.0 database?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialThis DSN-less database is being used by our ASP = templates.=20 Now, we want to use our CF templates tonbsp; be able to access this = same=20 database.. Any idea?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialOur webhost is Hostcentric (Virtualscape) so we = would be=20 asking them to donbsp; for us what your recommendations will = be../FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialTIA./FONT/DIV DIVFONT face=3DArialWinston/FONT/DIV/BODY/HTML --=_NextPart_000_003A_01C0A23D.8EED6040-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion access to a DSN-less SQL 7.0 =
this is not possible until CF 5 is released. There has to be an OLEDB dsn setup on the server. If this is done, you can pass the UID,PWD,DB Name, and the server name to access you database. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion access to a DSN-less SQL 7.0 =
see my previous reply -this is possible under odbc as long as you already have (and use) a ds already set up on the server (with associated login details etc...) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 11:09 To: CF-Talk Subject: RE: Coldfusion access to a DSN-less SQL 7.0 = this is not possible until CF 5 is released. There has to be an OLEDB dsn setup on the server. If this is done, you can pass the UID,PWD,DB Name, and the server name to access you database. HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion access to a DSN-less SQL 7.0 =
You are correct, but he is asking about DSN-less connections, which at this point is not possible. You can simulate DSN-less connections with a single OLEDB DSN, then you can connect to multiple databases just by changing the UID,PWD and other details. Your suggestion is not what this person is looking for - no offense. That is all I am saying. Clint ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: MS SQL 7.0 sp3
Anyone here using sp3? Having a regular occuring error with SQL 7.0 regarding parallel processing that is reportedly fixed in xp3. Any problems with the sp or any good news to report? Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS SQL 7.0 sp3
Anyone here using sp3? Having a regular occuring error with SQL 7.0 regarding parallel processing that is reportedly fixed in xp3. Any problems with the sp or any good news to report? been at sp3 for production a week or so after it was released. no problems so far. there was one problem mentioned on the sql server lists relating to the profiler against multiple boxes but ms has released a fix for that. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: Securing SQL 7.0 database
I think the second option of specifying the username and password in the query tag would work best - as it really isn't a globally available file - especially in an ISP environment. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 9:22 PM To: CF-Talk Subject: RE: Slightly OT: Securing SQL 7.0 database What's the best way to secure a database against access from other applications? I know you can specify the username and password in the datasource admin, but that allows other apps to use the datasource.. Specifying the username and password int he cfquery tag seems the best way to go, but that doesn't seem to work.. Not sure as to the best way, but we use this method and it works 1. Create SQL Server 7 database 2. Create a login account for the application that's going to read from/write to that database 3. Give that account the required permissions and access to that database 4. Go to the box that the site is going to be hosted on 5. Set up a SQL Server DSN from that machine to the SQL box 6. In the ODBC DSN settings, specify that is uses a SQL Server login (not NT) and provide the username/password combo for the account you previously created. 7. Also, click on Client Configuration and make sure it's using TCP/IP and not Named Pipes (the default, I think) 8. Test the datasource connects successfully 9. Go into the ColdFusion Administrator on the same box 10. Click on ODBC 11. Click on the DSN you've just created 12. Click on CF Settings 13. Enter the username and password into the username and password fields and update 14. Your queries should now by just referring to DATASOURCE="#YourDSNVarHere#" As you mentioned, all users now have access to the login account by just referring to the DSN. Not sure how to combat this. The alternative is to do everything described above without doing the CF Administrator bit. Then you have to add USERNAME="" and PASSWORD="" in all your CFQUERY tags. But then if someone peeks at your templates (or Application.cfm if you set it globally there), you've also given them access to your database. Each method seems to have its vulnerabilities. Maybe someone else could advise... ? -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT: Securing SQL 7.0 database
What's the best way to secure a database against access from other applications? I know you can specify the username and password in the datasource admin, but that allows other apps to use the datasource.. Specifying the username and password int he cfquery tag seems the best way to go, but that doesn't seem to work.. --- Regards, Darryl Lyons Web Development Team LogicWorld Internet Email : [EMAIL PROTECTED] Web : www.logicworld.com.au Team Site : webdevelopment.logicworld.com.au Phone : (07) 3230 8800 Fax : (07) 2320 8801 Technical Support : (07) 3230 8811 ' P L U G I N T O T H E W O R L D ' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: Securing SQL 7.0 database
What's the best way to secure a database against access from other applications? I know you can specify the username and password in the datasource admin, but that allows other apps to use the datasource.. Specifying the username and password int he cfquery tag seems the best way to go, but that doesn't seem to work.. Not sure as to the best way, but we use this method and it works 1. Create SQL Server 7 database 2. Create a login account for the application that's going to read from/write to that database 3. Give that account the required permissions and access to that database 4. Go to the box that the site is going to be hosted on 5. Set up a SQL Server DSN from that machine to the SQL box 6. In the ODBC DSN settings, specify that is uses a SQL Server login (not NT) and provide the username/password combo for the account you previously created. 7. Also, click on Client Configuration and make sure it's using TCP/IP and not Named Pipes (the default, I think) 8. Test the datasource connects successfully 9. Go into the ColdFusion Administrator on the same box 10. Click on ODBC 11. Click on the DSN you've just created 12. Click on CF Settings 13. Enter the username and password into the username and password fields and update 14. Your queries should now by just referring to DATASOURCE="#YourDSNVarHere#" As you mentioned, all users now have access to the login account by just referring to the DSN. Not sure how to combat this. The alternative is to do everything described above without doing the CF Administrator bit. Then you have to add USERNAME="" and PASSWORD="" in all your CFQUERY tags. But then if someone peeks at your templates (or Application.cfm if you set it globally there), you've also given them access to your database. Each method seems to have its vulnerabilities. Maybe someone else could advise... ? -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT - encryption for sql 7.0
At 14:21 1/10/01 -0600, you wrote: I've tried to get some help for this from the sql lists but haven't got any response, so I'm going with the trusty CF group on this. Is what I'm looking for is software to encrypt certain table fields in a sql 7.0 database. I would also like to here from any of you on how you handle sensitive data, either on the database side, or through your applications. I'm referring to things like credit card information. It depends on how you are delivering the final order to the merchant. Is it by email with the plain text credit card included? If so why even bother encrypting the data in the database, you're already sending plain text credit cards via the most easily hackable form of communication. If you are sending the merchant a secure, PGP encrypted credit card number, (as we do), then I would just store the encryped version of the credit card. Also store the last 4 digits clear text. Then when a user comes back to the site, you can show them the last 4 digits, and if they indeed do want to use that card, just use the PGP encrypted block you have stored. If anyone were to ever hack into your database, all they will get is a bunch of gibberish, its worthless without the private key file AND the associated password. You didn't really mention how you are going to use these cards, so I don't know if this info will really help you or not. Good luck. Ryan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT - encryption for sql 7.0
Here is a little snippet I use to encrypt and decrypt data that someone
posted to the list a while back
cfset
secret_word_encrypted=#ToBase64(encrypt("#customer_secret_word#","#customer_
last_name#1234"))#
cfset thevalue="#tostring(tobinary("#secret_word_encrypted"))#"
jon
- Original Message -
From: "Rick Lamb" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, January 10, 2001 3:21 PM
Subject: OT - encryption for sql 7.0
I've tried to get some help for this from the sql lists but haven't got
any
response, so I'm going with the trusty CF group on this. Is what I'm
looking
for is software to encrypt certain table fields in a sql 7.0 database. I
would also like to here from any of you on how you handle sensitive data,
either on the database side, or through your applications. I'm referring
to
things like credit card information.
Thanks,
Rick
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - encryption for sql 7.0
I've tried to get some help for this from the sql lists but haven't got any response, so I'm going with the trusty CF group on this. Is what I'm looking for is software to encrypt certain table fields in a sql 7.0 database. I would also like to here from any of you on how you handle sensitive data, either on the database side, or through your applications. I'm referring to things like credit card information. Thanks, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager (SQL 7.0) For SQL 2000
You can install just the Enterprise Manager using the SQL Server Install CD. I believe you choose 'install server', then 'install only server tools' or something to that effect. As I understand it, if you have CALs for SQL Server, then you are allowed to install Enterprise Manager on those machines. I'm certainly no licensing lawyer, so if anyone knows otherwise, let me know :) I still had trouble connecting to a SQL 2000 server from a remote machine; however. I'm going to try some of the suggestions. Norman Elton Information Technology College of William Mary -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 1:20 AM To: CF-Talk Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 Guys, I don't know what to say. I am using TCP IP and this isn't the issue its a version issue that I Don't even know if it can be resolved. I don't know if the server has a setting which says let lower version clients connect. I don't know where to allow people to download SQL 2k Enterprise manager. Any ideas?! Thanks, Neil - Original Message - From: "Chris Meier" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:35 PM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager (SQL 7.0) For SQL 2000
I need to find a website or a page on Microsoft's site where customers can download the client for their use. With SQL 7 you would download the trial and then you would have the client. As for licensing its based on per a processor. Thanks, Neil - Original Message - From: "Norman Elton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 16, 2000 7:32 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 You can install just the Enterprise Manager using the SQL Server Install CD. I believe you choose 'install server', then 'install only server tools' or something to that effect. As I understand it, if you have CALs for SQL Server, then you are allowed to install Enterprise Manager on those machines. I'm certainly no licensing lawyer, so if anyone knows otherwise, let me know :) I still had trouble connecting to a SQL 2000 server from a remote machine; however. I'm going to try some of the suggestions. Norman Elton Information Technology College of William Mary -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 1:20 AM To: CF-Talk Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 Guys, I don't know what to say. I am using TCP IP and this isn't the issue its a version issue that I Don't even know if it can be resolved. I don't know if the server has a setting which says let lower version clients connect. I don't know where to allow people to download SQL 2k Enterprise manager. Any ideas?! Thanks, Neil - Original Message - From: "Chris Meier" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:35 PM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Enterprise Manager (SQL 7.0) For SQL 2000
Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager (SQL 7.0) For SQL 2000
Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager (SQL 7.0) For SQL 2000
The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager (SQL 7.0) For SQL 2000
Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Enterprise Manager (SQL 7.0) For SQL 2000
Guys, I don't know what to say. I am using TCP IP and this isn't the issue its a version issue that I Don't even know if it can be resolved. I don't know if the server has a setting which says let lower version clients connect. I don't know where to allow people to download SQL 2k Enterprise manager. Any ideas?! Thanks, Neil - Original Message - From: "Chris Meier" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 1:35 PM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Just a guess, but are you using named pipes to connect? If so, try switching the client to TCP/IP. -Original Message- From: Neil H. To: CF-Talk Sent: 12/15/00 12:22 PM Subject: Re: Enterprise Manager (SQL 7.0) For SQL 2000 The error I receive is: You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server Please help?! Neil - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:52 AM Subject: RE: Enterprise Manager (SQL 7.0) For SQL 2000 Increase the timeout in Enterprise Manager to about 20 seconds. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 7:31 AM To: CF-Talk Subject: Enterprise Manager (SQL 7.0) For SQL 2000 Has anyone seen a problem whee the enterprise manager for SQL 7.0 will not connect to SQL Server 2000? I havea custome rwith this problem and I Don't know what could be the problem. I know i Have connected to SQL 2000 Servers with the SQL 7.0 Manager? Any ideas or suggestions? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
Change it to. cfquery name="get_auctions" datasource="happytoad" DELETE auction_records where auction_id='#id#' and userid='#userid#' /cfquery Mark -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 4:11 PM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
Nope. Try DELETE FROM At 11:11 AM 11/30/00 -0500, you wrote: Is * not the correct syntax for All is SQL 7.0? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
you don't need the NAME attribute of CFQUERY with DELETE. :) -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:12 AM To: CF-Talk Subject: RE: SQL 7.0 Question try cfquery name="get_auctions" datasource="happytoad" DELETE auction_records where auction_id='#id#' and userid='#userid#' /cfquery -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0
Can anyone recommend any online tutorials for newbies to SQL Server 7.0 database setup and conversiions from MS Access? For knowledge and help, I'd recommend www.swynk.com Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL 7.0 Question
Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
DELETE * from auction_records where auction_id='#id#' and userid='#userid#' Rich Just lose the star. The normal DELETE syntax is simply DELETE FROM... Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? In SQL, a DELETE statement inherently means to delete all columns. The * is redundant since there's no way to specify the columns you want to delete in a DELETE statement. Access probably ignored it; but to the best of my knowledge, that isn't technically correct SQL. SQL Server is kicking it out for that reason. The statement should be: DELETE FROM auction_records WHERE auction_id='#id#' AND userid='#userid#' (Caps of course are not important, but I like all my SQL keywords capped for readability...) Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOiaLNqvhLS1aWPxeEQLKKwCfVxX/QJ39/4OgI79p2wFVIlpTQb8AoLWn jE5qpxzPrhXBcyht8P6yRCl1 =XpCU -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
You don't need the * ... DELETE FROM will work just fine. Todd Ashworth - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 11:11 AM Subject: SQL 7.0 Question | Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything | works great except one statement. | | cfquery name="get_auctions" datasource="happytoad" | DELETE * from auction_records where auction_id='#id#' and userid='#userid#' | /cfquery | | Here is the error: | | ODBC Error Code = 37000 (Syntax error or access violation) | | [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near | '*'. | | Is * not the correct syntax for All is SQL 7.0? | | Thanks, | Rich | | ~~ | Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm | | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
You may want to use FROM instead of from, I am not sure if it is that picky or not, but * does mean all in SQL 7.0 as well. Robert - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 11:11 AM Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
No, just remove the asterisk (*) and it should work fine. In delete queries, it is assumed that you want to delete all records that match the criteria in the WHERE clause, unless you explicitly specify which fields to delete. -- Bruce -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 10:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
I'm guessing auction_id or userid are numeric -- not text -- fields; try removing the single quotes where appropriate. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 10:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
You are correct, just leave off the * - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 10:11 AM Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
I believe you want: cfquery name="get_auctions" datasource="happytoad" DELETE from auction_records where auction_id='#id#' and userid='#userid#' /cfquery in other words, you don't want that asterisk. ~Simon Simon Horwith Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
You do not need the *. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 10:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
Yes, you don't need * when doing a SQL delete statement. Dave -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 10:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
In Oracle you just use DELETE FROM TABLE. No * is necessary. Duncan Hays -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
If you're deleting, you don't need the "*". SQL Server understands that you want to delete the whole row just by saying "DELETE FROM tablename where something = 'somethingelse'". Evan -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
Take out the * in the Query in SQL all you need is cfquery name="get_auctions" datasource="happytoad" DELETE from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Instead of cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery You will need to do this on all you DELETE if you have many -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
Your statement for SQL would be: DELETE from auction_records where auction_id='#id#' and userid='#userid#' (basically delete the "*") Gregory Harris Web Developer Stirling Bridge Group LLC - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 8:11 AM Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
try cfquery name="get_auctions" datasource="happytoad" DELETE auction_records where auction_id='#id#' and userid='#userid#' /cfquery -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:11 AM To: CF-Talk Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 7.0 Question
That's right, don't use the * Just DELETE FROM ... WHERE ... Regards, Gaston -Mensaje original- De: ibtoad [SMTP:[EMAIL PROTECTED]] Enviado el: Jueves 30 de Noviembre de 2000 13:11 Para: CF-Talk Asunto: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
Try just DELETE FROM table WHERE conditions You'd have to use UPDATE to delete/mangle individual cell data, so the * in the previous statement is unnecessary. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: ibtoad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, November 30, 2000 2:24 PM Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7.0 Question
I'm surprised that statement worked in Access. The delete statement automatically deletes a whole row. You do not need to specify a wildcard, or column as you would in a select statement. cfquery name="get_auctions" datasource="happytoad" DELETE from auction_records where auction_id='#id#' and userid='#userid#' /cfquery ibtoad wrote: Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? Thanks, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
