[ic] Two sql questions

Kaare Rasmussen kar@webline.dk
Thu, 2 Nov 2000 21:57:01 +0100

> 	1. Have a SQL database

I do.

> 	2. Quote your query sql= parameter

Tried that too.

> 	3. Use [sql-pos 0] to access the return value

Here's the magic word. sql-pos! Thanks!
> which gives:
> 	197 countries

Hoohah! I'm using a lot of time (plus unnecessary black smoke and mirrors) 
just to format this the way I want. Interchange _is_ a comples environment, 
so it takes time to find the necessary tools. For now I'm relying on good old 
Perl. :-)

> It will select all of them. It would make sense to use a "limit"
> parameter if your DB supports it.

Thought so. I'm using PostgreSQL which supports limit. I did hope that there 
was some magic there, but didn't count on it :-)

Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        Lørdag 11.00-17.00       Web:      www.suse.dk