[ic] ANOTHER SQL STATEMENT QUESTION
joachim.richter
interchange-users@interchange.redhat.com
Thu Nov 29 12:54:01 2001
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