Post Reply  Post Thread 
Recordset
Author Message
Carduel
Redoviti posjetitelj
**


Posts: 99
Group: Registered
Joined: Jul 2006
Status: Offline
Reputation: 0
Post: #1
Recordset

Kada napravim upit sa SELECT * FROM tblBanner ORDER BY RND (LEN([filename])) onda mi se izlistaju svi recordi a ja bi htio to ograničiti na jedan slučajan izbor pomoću LIMIT 1 tako da sql upit glasi SELECT * FROM tblBanner ORDER BY RND (LEN([filename])) LIMIT 1. Kada ovo testiram javi mi da je negdje sintax greška.

Dal se netko susretao sa ovim problemom?

RND (LEN([filename])) je dodan iz razloga što se radi o access bazi a za mysql može samo RAND() umjesto RND (LEN([nesto])).

11-11-2006 09:49 PM
Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: