table aliases

[fiona cosgrove]

Brilliant, thanks Frank. The single quotes were
causing all the problems so I took them out and all
the strings work. 

I do feel rather the fool ! :)


Thank you Frank, & Ruslan 

Fiona


 --- Frank Schima <frank-list2 at mindstarprods.com>
wrote: > 
> On Mar 17, 2004, at 11:01 AM, fiona cosgrove wrote:
> 
> >  -------------
> >  1) code with ORDER By in the sql string
> >  ------------
> 
> >  sqlstringS = string(" 'select wstr_id,
> wstr_title,
> >  ai_count from wstr, ai, aw where ai_wstr_id =
> >  wstr_id
> >  and ai_wwrd_id = aw_id and aw_word = 'biology'
> order
> >  by ai_count' ")
> 
> >  ----------------
> >  2) code Without the ORDER BY in the sql string,
> this
> >  works
> >  ----------------
> 
> >   sqlstringS = string(" 'select wstr_id,
> wstr_title,
> >  ai_count from wstr, ai, aw where ai_wstr_id =
> >  wstr_id
> >  and ai_wwrd_id = aw_id and aw_word = 'biology'
> '")
> 
> I think you many have too many quotes. You seem to
> enclose your SQL 
> String with single quotes inside the string. Remove
> the single quotes 
> surrounding the SQL statement and try it.
> 
> 
> -Frank
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina 


	
	
		
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html