Perry:
For any database programming it is very important for one to bone
up on SQL. Having said that there is an easy way to learn. Use MS
Access Query design and fashion the query you want. Then switch
to SQL window (click on the arrow next to the set square icon on
top left). Voila! You will see the SQL.
I almost always test out my SQL by pasting it in MS Access
window and checking for syntax. Then I paste it back in the
program and make any ncessary corrections.
Also MS Access help is decent and you can look at examples and
learn from it...
Ranga Nathan
Reliance Technology Consultatns Inc.
On 26 May 00, at 8:46, Anthony George wrote:
Date sent: Fri, 26 May 2000 08:46:48 -0400
From: "Anthony George" <[EMAIL PROTECTED]>
Organization: EMS Technical Services
To: "Perl-Win32-Users Mailing List"
<[EMAIL PROTECTED]>
Subject: Re: Data access
Send reply to: "Anthony George" <[EMAIL PROTECTED]>
>
> [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: [EMAIL PROTECTED]
> To unsubscribe, forward this message to
> [EMAIL PROTECTED]
> For non-automated Mailing List support, send email to
> [EMAIL PROTECTED]
>
>
---
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]
