Re: Troubleshooting SQL server

2008-04-16 Thread aspiritus
On Apr 15, 3:52 am, [EMAIL PROTECTED] (Chas. Owens) wrote: > On Mon, Apr 14, 2008 at 7:11 PM, Jenda Krynicky <[EMAIL PROTECTED]> wrote: > > snip> > my $sql = q/SELECT Account,Last_Name,First_Name,Email_Address FROM > > > prospects WHERE Email_Address='?'/; > > > Drop the singlequotes. This way

Re: Troubleshooting SQL server

2008-04-15 Thread aspiritus
On 15 huhti, 03:52, [EMAIL PROTECTED] (Chas. Owens) wrote: > On Mon, Apr 14, 2008 at 7:11 PM, Jenda Krynicky <[EMAIL PROTECTED]> wrote: > > snip> > my $sql = q/SELECT Account,Last_Name,First_Name,Email_Address FROM > > > prospects WHERE Email_Address='?'/; > > > Drop the singlequotes. This way

Re: Troubleshooting SQL server

2008-04-14 Thread Chas. Owens
On Mon, Apr 14, 2008 at 7:11 PM, Jenda Krynicky <[EMAIL PROTECTED]> wrote: snip > > my $sql = q/SELECT Account,Last_Name,First_Name,Email_Address FROM > > prospects WHERE Email_Address='?'/; > > Drop the singlequotes. This way your SQL searches for a literal > questionmark in the Email_Addres

Re: Troubleshooting SQL server

2008-04-14 Thread Jenda Krynicky
From: "Pat Rice" <[EMAIL PROTECTED]> > Hi all > I'm looking for some good ideas on trouble shooting SQL. > > as in I have wrote thsi code, but I wondering if there is any way we > can a debug level, so that it would tell me if the query failed. > eg. > my $sql = q/SELECT Account,Last_Name,First_N

Re: Troubleshooting SQL server

2008-04-14 Thread Chas. Owens
On Apr 14, 2008, at 10:40, Jeff Pang wrote: On Mon, Apr 14, 2008 at 10:35 PM, Pat Rice <[EMAIL PROTECTED]> wrote: Hi all I'm looking for some good ideas on trouble shooting SQL. as in I have wrote thsi code, but I wondering if there is any way we can a debug level, so that it would tell me

Re: Troubleshooting SQL server

2008-04-14 Thread Jeff Pang
On Mon, Apr 14, 2008 at 10:35 PM, Pat Rice <[EMAIL PROTECTED]> wrote: > Hi all > I'm looking for some good ideas on trouble shooting SQL. > > as in I have wrote thsi code, but I wondering if there is any way we > can a debug level, so that it would tell me if the query failed. > eg. > my $sql = q

Troubleshooting SQL server

2008-04-14 Thread Pat Rice
Hi all I'm looking for some good ideas on trouble shooting SQL. as in I have wrote thsi code, but I wondering if there is any way we can a debug level, so that it would tell me if the query failed. eg. my $sql = q/SELECT Account,Last_Name,First_Name,Email_Address FROM prospects WHERE Email_Addre