View Single Post
Old 02-14-2013, 05:55 PM   PM User | #4
bazz
Master Coder

 
Join Date: Apr 2003
Location: in my house
Posts: 5,211
Thanks: 39
Thanked 201 Times in 197 Posts
bazz will become famous soon enoughbazz will become famous soon enough
Hi Fishmonger

if I remove the line
Code:
$_ = qq('$_') for @business_types;
I get the error message

Code:
execute statement failed: Unknown column 'Accommodation' in 'on clause'
But then, if having removed it, if I use the following execute statement, it seems to work.

Code:
$sth2->execute( @business_types_to_exclude
                , $base_latitude_miles
                , $base_longitude
                , $base_radius
                , $base_radius
                , $base_radius
                , $base_radius
                , $base_radius
                )or die "execute statement failed: $DBI::errstr\n";
is that the correct way to do it?

bazz
__________________
"The day you stop learning is the day you become obsolete"! - my late Dad.

Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
Useful MySQL resource
Useful MySQL link
bazz is offline   Reply With Quote