CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Help on mysql query

 



rajiv_chennai
Novice

Feb 9, 2008, 12:39 AM

Post #1 of 2 (3329 views)
Help on mysql query Can't Post

 

Code
my $select=$dbh->selectrow_hashref("SELECT mfqno FROM hq_stock_details WHERE mfqno = (SELECT max(mfqno)FROM hq_stock_details where mfqno LIKE \'XTC\%\' )AND mfqno LIKE \'XTC\%\'") or die $DBI::errstr;


it gives sql syntax error.but i could not find any error.

Is any idea please.

Regards
Rajiv


eWish
User

Feb 20, 2008, 7:39 PM

Post #2 of 2 (3247 views)
Re: [rajiv_chennai] Help on mysql query [In reply to] Can't Post

Have you already figured out your problem with your query?


If , not what errors are you getting from mysql? Also, what version are your running? Does your version allow for the use of subqueries?

--Kevin

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives