[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] ANOTHER SQL STATEMENT QUESTION
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
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users