Re: RE: RE: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread ksuh

I don't think you'd use a servlet.  I would create a Java class that 
allows me to specify the connect string for the database connection, 
execute sql, and close the connection.  You could then wrap this whole 
thing in a CF custom tag.

Hmm, I suppose if I have absolutely nothing to do on Sunday, I could 
mess around with this.

- Original Message -
From: Joshua Miller <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 11:05 am
Subject: RE: RE: RE: CFQuery Error - No more ConnectString ???

> So using a servlet I could basically bypass the CFMX Merant 
> drivers and
> construct my own "CFQUERY" ?
> 
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, June 14, 2002 12:57 PM
> To: CF-Talk
> Subject: Re: RE: RE: CFQuery Error - No more ConnectString ???
> 
> 
> It was probably lazy programmers :)
> 
> - Original Message -
> From: Dave Watts <[EMAIL PROTECTED]>
> Date: Friday, June 14, 2002 10:47 am
> Subject: RE: RE: CFQuery Error - No more ConnectString ???
> 
> > > Really odd. The thing is, it's really easy to create dynamic
> > > connections in Java using JDBC. Like, it's so simple it ain't 
> > > even funny. I do it all the time.
> > 
> > I guess I'd have been more accurate in saying "the versions of the
> > Merantdrivers included with CF MX don't support dynamic 
> > connections." Or, perhaps,
> > it's not even the drivers' fault at all - it might be the way 
> that 
> > CF MX
> > works with the drivers. I don't really know why that is. For all 
> I 
> > know, the
> > versions that do support dynamic connections cost too much for 
> MM to
> > include.
> > 
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> > 
> 
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Jason Miller

Would I be able to use these "servlets" you guys are referring to to
access database tables on a 3rd party site - completely different url
and ISP ?

If yes - and someone has any samples or sites that have examples.. I
would greatly appreciate it.
jay miller

Cravens, Billy wrote:


Absolutely.

---
Billy Cravens
 

-Original Message-
From: Joshua Miller [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
] 
Sent: Friday, June 14, 2002 12:06 PM
To: CF-Talk
Subject: RE: RE: RE: CFQuery Error - No more ConnectString ???

So using a servlet I could basically bypass the CFMX Merant drivers and
construct my own "CFQUERY" ?

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com <http://www.eaglewd.com> 
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From:  [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>  [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> 

] 
Sent: Friday, June 14, 2002 12:57 PM
To: CF-Talk
Subject: Re: RE: RE: CFQuery Error - No more ConnectString ???


It was probably lazy programmers :)

- Original Message -
From: Dave Watts   <mailto:[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more ConnectString ???


Really odd. The thing is, it's really easy to create dynamic
connections in Java using JDBC. Like, it's so simple it ain't 
even funny. I do it all the time.

I guess I'd have been more accurate in saying "the versions of the
Merantdrivers included with CF MX don't support dynamic 
connections." Or, perhaps,
it's not even the drivers' fault at all - it might be the way that 
CF MX
works with the drivers. I don't really know why that is. For all I 
know, the
versions that do support dynamic connections cost too much for MM to
include.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ <http://www.figleaf.com/> 
voice: (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: RE: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Cravens, Billy

Absolutely.

---
Billy Cravens
 

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 12:06 PM
To: CF-Talk
Subject: RE: RE: RE: CFQuery Error - No more ConnectString ???

So using a servlet I could basically bypass the CFMX Merant drivers and
construct my own "CFQUERY" ?

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 12:57 PM
To: CF-Talk
Subject: Re: RE: RE: CFQuery Error - No more ConnectString ???


It was probably lazy programmers :)

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more ConnectString ???

> > Really odd. The thing is, it's really easy to create dynamic
> > connections in Java using JDBC. Like, it's so simple it ain't 
> > even funny. I do it all the time.
> 
> I guess I'd have been more accurate in saying "the versions of the
> Merantdrivers included with CF MX don't support dynamic 
> connections." Or, perhaps,
> it's not even the drivers' fault at all - it might be the way that 
> CF MX
> works with the drivers. I don't really know why that is. For all I 
> know, the
> versions that do support dynamic connections cost too much for MM to
> include.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: RE: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Joshua Miller

So using a servlet I could basically bypass the CFMX Merant drivers and
construct my own "CFQUERY" ?

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 12:57 PM
To: CF-Talk
Subject: Re: RE: RE: CFQuery Error - No more ConnectString ???


It was probably lazy programmers :)

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more ConnectString ???

> > Really odd. The thing is, it's really easy to create dynamic
> > connections in Java using JDBC. Like, it's so simple it ain't 
> > even funny. I do it all the time.
> 
> I guess I'd have been more accurate in saying "the versions of the
> Merantdrivers included with CF MX don't support dynamic 
> connections." Or, perhaps,
> it's not even the drivers' fault at all - it might be the way that 
> CF MX
> works with the drivers. I don't really know why that is. For all I 
> know, the
> versions that do support dynamic connections cost too much for MM to
> include.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Joshua Miller

I did those exact same things and my help file looks like it did in CF5
- think I need to reinstall. I get CFMX notes if I search, but not when
I look at the tags in the tree. Probably screwed up the booktree.xml
file.

Thanks,

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 12:29 PM
To: CF-Talk
Subject: RE: CFQuery Error - No more ConnectString ???


I downloaded the new help files from Macromedia and followed the 
instructions.  Add booktree.xml to your CFStudio booktree.xml, and 
click on the 'search' to re-run the indexing.  When the indexing is
done, all the CFMX 
documentation / update / changes should now be visible.

In the case, I just simply looked up cfquery in my cfml references ->
cfml 
tags -> cfquery in the help.

~Todd

On Fri, 14 Jun 2002, Joshua Miller wrote:

> What part of the help files did you find this in? I think I'm missing 
> the documentation.
> 
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 12:07 PM
> To: CF-Talk
> Subject: Re: CFQuery Error - No more ConnectString ???
> 
> 
> Straight from the help file:
> 
> New in ColdFusion MX: The connectString, dbName, dbServer, provider,
> providerDSN, and sql attributes, and all values of the dbtype
attribute 
> except query, are deprecated. Do not use them. They do not work, and
> might 
> cause an error, in releases later than ColdFusion 5.
> 
> ~Todd
> 

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: RE: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread ksuh

Oh, my real answer is:

Normally, in Java, one creates a datasource object, and then connect to 
a database using a connection string.  Then, you do your SQL operations 
then close the database connection.  You can save yourself some time 
with coding by creating a wrapper class that does the connecting for 
you, and then call that object each time instead of instantiating the 
datasource object directly.

In fact, I can't think of a reason why CFMX couldn't support dynamic 
connections, even with the Merant drivers.  If they're Type IV drivers 
(and I'm positive they are), they've gotta implement the JDBC API, part 
of which is what I explained above.

Someone could easily write a custom tag that allows dynamic query 
connections, I suppose.

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more ConnectString ???

> > Really odd. The thing is, it's really easy to create dynamic 
> > connections in Java using JDBC. Like, it's so simple it ain't 
> > even funny. I do it all the time.
> 
> I guess I'd have been more accurate in saying "the versions of the 
> Merantdrivers included with CF MX don't support dynamic 
> connections." Or, perhaps,
> it's not even the drivers' fault at all - it might be the way that 
> CF MX
> works with the drivers. I don't really know why that is. For all I 
> know, the
> versions that do support dynamic connections cost too much for MM to
> include.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: RE: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread ksuh

It was probably lazy programmers :)

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more ConnectString ???

> > Really odd. The thing is, it's really easy to create dynamic 
> > connections in Java using JDBC. Like, it's so simple it ain't 
> > even funny. I do it all the time.
> 
> I guess I'd have been more accurate in saying "the versions of the 
> Merantdrivers included with CF MX don't support dynamic 
> connections." Or, perhaps,
> it's not even the drivers' fault at all - it might be the way that 
> CF MX
> works with the drivers. I don't really know why that is. For all I 
> know, the
> versions that do support dynamic connections cost too much for MM to
> include.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (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: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Dave Watts

> Really odd. The thing is, it's really easy to create dynamic 
> connections in Java using JDBC. Like, it's so simple it ain't 
> even funny. I do it all the time.

I guess I'd have been more accurate in saying "the versions of the Merant
drivers included with CF MX don't support dynamic connections." Or, perhaps,
it's not even the drivers' fault at all - it might be the way that CF MX
works with the drivers. I don't really know why that is. For all I know, the
versions that do support dynamic connections cost too much for MM to
include.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (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: RE: CFQuery Error - No more ConnectString ???

2002-06-14 Thread ksuh

Really odd.  The thing is, it's really easy to create dynamic 
connections in Java using JDBC.  Like, it's so simple it ain't even 
funny.  I do it all the time.

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Friday, June 14, 2002 10:31 am
Subject: RE: CFQuery Error - No more ConnectString ???

> > Wow, why did they remove that? Something to do with JDBC 
> > or what? Why would they remove that feature?
> 
> JDBC doesn't support it, apparently, so they had no choice. This is
> described in the release notes, I think, as well as within the regular
> documentation. Also, if you're using SQL Server trusted 
> connections, the SQL
> Server JDBC drivers don't support those either.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread todd

I downloaded the new help files from Macromedia and followed the 
instructions.  Add booktree.xml to your CFStudio booktree.xml, and 
click on the 'search' to re-run the indexing.  When the indexing is done, all the CFMX 
documentation / update / changes should now be visible.

In the case, I just simply looked up cfquery in my cfml references -> cfml 
tags -> cfquery in the help.

~Todd

On Fri, 14 Jun 2002, Joshua Miller wrote:

> What part of the help files did you find this in? I think I'm missing
> the documentation.
> 
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, June 14, 2002 12:07 PM
> To: CF-Talk
> Subject: Re: CFQuery Error - No more ConnectString ???
> 
> 
> Straight from the help file:
> 
> New in ColdFusion MX: The connectString, dbName, dbServer, provider, 
> providerDSN, and sql attributes, and all values of the dbtype attribute 
> except query, are deprecated. Do not use them. They do not work, and
> might 
> cause an error, in releases later than ColdFusion 5.
> 
> ~Todd
> 

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
Get the mailserver that powers this list at http://www.coolfusion.com
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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Joshua Miller

What part of the help files did you find this in? I think I'm missing
the documentation.

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 12:07 PM
To: CF-Talk
Subject: Re: CFQuery Error - No more ConnectString ???


Straight from the help file:

New in ColdFusion MX: The connectString, dbName, dbServer, provider, 
providerDSN, and sql attributes, and all values of the dbtype attribute 
except query, are deprecated. Do not use them. They do not work, and
might 
cause an error, in releases later than ColdFusion 5.

~Todd

On Fri, 14 Jun 2002, Joshua Miller wrote:

> Attribute validation error for tag query.
> The tag does not have an attribute called connectstring. The valid
> attribute(s) are name, datasource, dbtype, sql, username, password,
> maxrows, blockfactor, timeout, cachedafter, cachedwithin, debug. 
>  
> The Error Occurred in D:\websites\wvbuilders\directory.cfm: line 24
> 
> 22 : Uid=;
> 23 : Pwd=;">
> 24 :  name="qGetEmp">
> 25 : SELECT * FROM tblEmployees
> 26 : ORDER BY elastname ASC, efirstname ASC
> 
> 
> What's up? The help from CFMX doesn't say anything to the contrary 
> about this ... Is connectString deprecated in CFMX?
> 
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
> 
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Dave Watts

> Wow, why did they remove that? Something to do with JDBC 
> or what? Why would they remove that feature?

JDBC doesn't support it, apparently, so they had no choice. This is
described in the release notes, I think, as well as within the regular
documentation. Also, if you're using SQL Server trusted connections, the SQL
Server JDBC drivers don't support those either.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Joshua Miller

Wow, why did they remove that? Something to do with JDBC or what? Why
would they remove that feature?

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


-Original Message-
From: Cravens, Billy [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 11:57 AM
To: CF-Talk
Subject: RE: CFQuery Error - No more ConnectString ???


Not deprecated; it was removed.

---
Billy Cravens
 

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 10:53 AM
To: CF-Talk
Subject: CFQuery Error - No more ConnectString ???

Attribute validation error for tag query. 
The tag does not have an attribute called connectstring. The valid
attribute(s) are name, datasource, dbtype, sql, username, password,
maxrows, blockfactor, timeout, cachedafter, cachedwithin, debug. 
 
The Error Occurred in D:\websites\wvbuilders\directory.cfm: line 24

22 : Uid=;
23 : Pwd=;">
24 : 
25 : SELECT * FROM tblEmployees
26 : ORDER BY elastname ASC, efirstname ASC


What's up? The help from CFMX doesn't say anything to the contrary about
this ... Is connectString deprecated in CFMX?

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread todd

Straight from the help file:

New in ColdFusion MX: The connectString, dbName, dbServer, provider, 
providerDSN, and sql attributes, and all values of the dbtype attribute 
except query, are deprecated. Do not use them. They do not work, and might 
cause an error, in releases later than ColdFusion 5.

~Todd

On Fri, 14 Jun 2002, Joshua Miller wrote:

> Attribute validation error for tag query. 
> The tag does not have an attribute called connectstring. The valid
> attribute(s) are name, datasource, dbtype, sql, username, password,
> maxrows, blockfactor, timeout, cachedafter, cachedwithin, debug. 
>  
> The Error Occurred in D:\websites\wvbuilders\directory.cfm: line 24
> 
> 22 : Uid=;
> 23 : Pwd=;">
> 24 :  name="qGetEmp">
> 25 : SELECT * FROM tblEmployees
> 26 : ORDER BY elastname ASC, efirstname ASC
> 
> 
> What's up? The help from CFMX doesn't say anything to the contrary about
> this ... Is connectString deprecated in CFMX?
> 
> Joshua Miller
> Web Development :: Programming
> Eagle Web Development LLC
> www.eaglewd.com
> [EMAIL PROTECTED]
> (304) 622-5676 (Clarksburg Office)
> (304) 456-4942 (Home Office)
> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Critz

oi Joshua!!


it is ..has to do with the jdbc or sumfin

-- 
Best regards,

Critter, MMCP
Certified ColdFusion Developer
 
Crit[s2k] - 


Friday, June 14, 2002, 11:52:53 AM, you wrote:

JM> Attribute validation error for tag query. 
JM> The tag does not have an attribute called connectstring. The valid
JM> attribute(s) are name, datasource, dbtype, sql, username, password,
JM> maxrows, blockfactor, timeout, cachedafter, cachedwithin, debug. 
 
JM> The Error Occurred in D:\websites\wvbuilders\directory.cfm: line 24

JM> 22 : Uid=;
23 : Pwd=;">>
JM> 24 : >
JM> 25 : SELECT * FROM tblEmployees
JM> 26 : ORDER BY elastname ASC, efirstname ASC


JM> What's up? The help from CFMX doesn't say anything to the contrary about
JM> this ... Is connectString deprecated in CFMX?

JM> Joshua Miller
JM> Web Development :: Programming
JM> Eagle Web Development LLC
JM> www.eaglewd.com
JM> [EMAIL PROTECTED]
JM> (304) 622-5676 (Clarksburg Office)
JM> (304) 456-4942 (Home Office)

JM> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CFQuery Error - No more ConnectString ???

2002-06-14 Thread Cravens, Billy

Not deprecated; it was removed.

---
Billy Cravens
 

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
Sent: Friday, June 14, 2002 10:53 AM
To: CF-Talk
Subject: CFQuery Error - No more ConnectString ???

Attribute validation error for tag query. 
The tag does not have an attribute called connectstring. The valid
attribute(s) are name, datasource, dbtype, sql, username, password,
maxrows, blockfactor, timeout, cachedafter, cachedwithin, debug. 
 
The Error Occurred in D:\websites\wvbuilders\directory.cfm: line 24

22 : Uid=;
23 : Pwd=;">
24 : 
25 : SELECT * FROM tblEmployees
26 : ORDER BY elastname ASC, efirstname ASC


What's up? The help from CFMX doesn't say anything to the contrary about
this ... Is connectString deprecated in CFMX?

Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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