Many thanks,
It was so easy, isn't it ?
:o)
Now, i need to play with session variables to remember the user is
authenticated.
I certainly be back on this list soon :)))
CG
----- Original Message -----
From: "Vijay Menon" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 10:58 AM
Subject: Re: Newbie : something like record.count ?
> When the recordset is returned, the pointer refers to before the first
row.
> So, to make it point to the 1st row, u have to call rs.next();
>
> To process any records, simply use
> if (rs.next()) {
> // put your code here
> }
>
> This should take care of it.
>
> ----- Original Message -----
> From: "Christian Gayton" <[EMAIL PROTECTED]>
> To: "JRun-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 24, 2001 6:41 PM
> Subject: Newbie : something like record.count ?
>
>
> > Hi all,
> >
> > Just starting with jrun and jrun studio.
> > I can connect to my SQL db with jrun tag, and with foreach, i can also
> view
> > recordset, cool :)
> > When i developp with CF, it's easy to detect if record.count is empty or
> > not, and do the stuff dependant
> > I tried several thing yesterday to do a similar thing with jsp, and
> couldn't
> > make it work.
> > Here is a piece of code :
> > ........
> > <jrun:sql datasrc="zzzzzzzzzzzzz" id="q1" scope="page"
> > username="xxxxxxxxxxxx" password="yyyyyyyyyyy" >
> > select * from tbl_users where login='<%=request.getParameter("login")%>'
> and
> > password='<%=request.getParameter("password")%>'
> > </jrun:sql>
> >
> > <jrun:param id="q1" type="QueryTable"/>
> >
> > Here, i'd like to detect if recordset is empty or not. If yes, the
> redirect
> > the user to a form, if not, then continue the process...
> >
> > I tried to play with q1.getRow(), but with no success...
> >
> > Any help for a so simple thing !!!
> >
> > TIA
> > Christian Gayton
> >
> > Net-Lines
> > 61 rue Sully
> > 69006 Lyon
> > Tel : 33+472.829.777
> > Fax : 33+472.829.897
> > http://www.net-lines.com
> > [EMAIL PROTECTED]
> >
> >
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
