RE: SQL Generators
Why don't you create the query in the GUI tools in Access, and then cutnpaste them to your CF code (with minor modifications). I often do that, to test that they work find. - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Brad Roberts [mailto:[EMAIL PROTECTED] | Sent: Thursday, November 13, 2003 18:34 | To: CF-Talk | Subject: SQL Generators | | | Anyone know of software (desktop or CF based), that will generate SQL | (select, insert, update, etc.), by simply pointing to an | Access database? | Generating cfqueryparam's would be a bonus. | | -Brad | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Generators
Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Generators
I know there exists something like that, but I am not sure about cfqueryparam part. As for myself I prefer to use SQL server enterprise manager for query building -- very fast way to do a complex query or select a whole table etc. TK - Original Message - From: Brad Roberts To: CF-Talk Sent: Thursday, November 13, 2003 12:34 PM Subject: SQL Generators Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Generators
Download a copy of DatabaseBlocks V2.1 from http://www.ProductivityEnhancement.com and see if it does what you want. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training ColdFusion MX Master Class: January 12 - 16, 2004 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:34 PM Subject: SQL Generators Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Generators
Databaseblocks doesn't seem to be available on that site. -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:26 PM To: CF-Talk Subject: Re: SQL Generators Download a copy of DatabaseBlocks V2.1 from http://www.ProductivityEnhancement.com and see if it does what you want. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training ColdFusion MX Master Class: January 12 - 16, 2004 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:34 PM Subject: SQL Generators Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Generators
Databaseblocks doesn't seem to be available on that site. -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:26 PM To: CF-Talk Subject: Re: SQL Generators Download a copy of DatabaseBlocks V2.1 from http://www.ProductivityEnhancement.com and see if it does what you want. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training ColdFusion MX Master Class: January 12 - 16, 2004 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:34 PM Subject: SQL Generators Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Generators
Sorry... It's listed as CommerceBlocks V2.1 under the Products link. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training ColdFusion MX Master Class: January 12 - 16, 2004 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 2:00 PM Subject: RE: SQL Generators Databaseblocks doesn't seem to be available on that site. -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 1:26 PM To: CF-Talk Subject: Re: SQL Generators Download a copy of DatabaseBlocks V2.1 from http://www.ProductivityEnhancement.com and see if it does what you want. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training ColdFusion MX Master Class: January 12 - 16, 2004 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:34 PM Subject: SQL Generators Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Generators
Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. You might want to check out SqlGen at: http://www.aloha-webdesign.com/ It's helped me in prototyping. HTH, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]