[ic] ANOTHER SQL STATEMENT QUESTION

[joachim.richter]

Hi list,

I am trying desperately to somehow change this query 

[query list=1 st=db ml=50 sql=|
    select * from trailer where trailer >= '1'
        |
        ] [sql-increment] [sql-code] [sql-field title]<br>[/query]

into a link.

Is the link below now working with the SQL database and
being a correct SQL link or not ?

<a href="[area scan
fi=trailer
st=db
co=1
sf=trailer
se=1
op=>=
nu=1
ml=50
"]
>Test</a>

What do I have to change to achieve the same neckbreaking speed that
the query above delivers ?
Or does anybody have an example for a correct SQL - link ?

We are using a MYSQL database and Interchange 4.81.

Thanx JoE

US Video Center Medien GmbH
Heimsheimer Str 22
70499 Stuttgart

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