<cfquery>
SP_TABLES 'tname'
</cfquery>
it will just return a recordset
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Chad
Renando
Sent: Monday, May 16, 2005 2:54 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Test for SQL Table
Sorry, about one step behind ya' all. How would that look in my CF page?
Chad
Who has been waiting for a chance to use ya' all
On 5/16/05, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> sorry
>
> the TYPE needs to be like that
>
> EXEC sp_tables syscolumns, dbo, Company, "'SYSTEM TABLE'"
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf
> Of Shane Farmer
> Sent: Monday, May 16, 2005 2:34 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: Test for SQL Table
>
>
> Steve,
>
> Do you mean exec sp_tables 'table_name' ?
>
> With this you can even use '%ble%' to get like matches.
>
> Shane--- You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED] To unsubscribe send a blank email to
> [EMAIL PROTECTED] Aussie Macromedia
> Developers: http://lists.daemon.com.au/ ---
>
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED] Aussie Macromedia
> Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
