[EMAIL PROTECTED] wrote:
>
> I have another situation where I am calling a select subroutine in PERL
> based on the table a user selects. This select statement is very basic:
>
> select * from $tablename
>
> From here how do I pick only the columns of my choice?
>
> Perry Chaturvedi
You'll probably get better response from Perl-Win32-Database,
but, the select statement you have is selecting all fields in $tablename
you'll need to be more specific:
SELECT (FIELD1,FIELD2,FIELD3) FROM $tablename WHERE FIELD1 LIKE
$string ##untested, maybe incorrect on the WHERE
This would return FIELD1,FIELD2,FIELD3 from $tablename where FIELD1 is
like $string(kind of like FIELD1=~/$string/ of sorts)
I found quite a bit of docs searching on google:
http://www.google.com/search?q=sql+select&meta=lr%3D%26hl%3Den
for SQL server and ODBC/Access
>tony
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]