[ic] SQL ?

joachim.richter interchange-users@interchange.redhat.com
Tue Dec 4 12:55:01 2001


Thanks for the answer Jon,

as I read my last question, i realised that I forgot to mail the top section
with all the details like we are using interchange 4.81 and a MYSQL database
sorry about that.

I understand that

[query more=1 ml=10 st=sql sql=|
SELECT sku FROM products
WHERE category = 'TEST'
|]

and

[list][sql-item description][/list][/query]

will actually access the sql database via sql statements and is therefore superfast.

Heres a try to use an SQL statements in a link

<a href="[area href=scan arg=|
SELECT sku FROM products
WHERE category = 'TEST'
|]">CLICK ME</a>

the link actually works, but if I check the bottom line of the browser (by moving the mouse on the link)

I read : ..../scan/fi=products.txt/rf=sku/co=yes/nu=0/se=TEST/op==/sf=category/ne=0.html

now the link accesses the textfile and not the database directly,
which means somehow I have to get the st=sql in there !
>From my amateur point of view I believe that interchange changes the
qualified sql statement into an interchange link, because the link gives me a
BAD_SQL if I add this to the statement ORDER BY category ASC LIMIT 50

well basically then the link you gave me (below) is the same except the missing st=sql

<a href="[area href=scan arg=|
	fi=products
	st=sql
	co=1
	sf=category
	se=TEST
	ml=10
|]">CLICK ME</a>

See the reason for those questions is the amazing difference in speed. The query gives an results within seconds
while the link takes a lot longer. 

What I like to know is how to change the link therefore it also accesses the SQL database via SQL statements
to achieve the same breathtaking speed the query has.

Or am I like completely mistaken ? If that is so I am really sorry, but I just bought a book on MYSQL and I am
doing my first steps so to speak, and thats where I got the idea from, because even the most complicated query
pops up results within seconds.

JoE

US Video Center Medien GmbH
Heimsheimer Str 22
70499 Stuttgart

Tel 0711 880252 0
Fax 0711 880252 22
Email joachim.richter@usvideocenter.de