Ask a Question related to ASP Database, Design and Development.
-
Ray at #1
Re: Check if record set rturn something
Try:
If rstPart.Fields.Item("partID").Value < 0 Then ...
Is it a numeric value in the column? Is it possible that it's null?
If CDbl(rstPart.Fields.Item("partID").Value & "") < 0 Then ...
Ray at work
"viktor" <serguienkov@hotmail.com> wrote in message
news:%23p8uBavnDHA.684@TK2MSFTNGP09.phx.gbl...> Hi i am trying to see if the query return some data
> but i am getting error:(0x80020009)
> Exception occurred.
> here is the code:
>
> if rstPart("partID")<0 then
> response.redirect("new_part_no.asp")
> end if
>
> thanks
>
>
Ray at Guest
-
Check the record in Database using ASP.NET
Dear All, Dreamweaver user who want to develop a site using ASP.NET have got critical time. In Server behavious we doesn't have User... -
Check record before Inserting
Hi, I have troble in inserting new records into database, I have a unique date field it should not repeate again, i.e. one record per single day,... -
Check new username on Update record??
Hi - using ASP/Access/Vbscript. How can I use the "check new username" behaviour in DW on UPDATE RECORD? DW tells me that it needs an insert... -
HELP ME : check for locked record
How can i check if the record i want to select is already locked by another user? There is a way to know the resource id associated with the record... -
Check for locked record
How can i check if the record i want to select is already locked by another user? There is a way to know the resource id associated with the record... -
viktor #2 Check if record set rturn something
Hi i am trying to see if the query return some data
but i am getting error:(0x80020009)
Exception occurred.
here is the code:
if rstPart("partID")<0 then
response.redirect("new_part_no.asp")
end if
thanks
viktor Guest
-
viktor #3 Re: Check if record set rturn something
what i am trying to do is:
when user type a part number and this part number doesn't exist to be
redirect to a diferent page.
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uxsKabvnDHA.964@TK2MSFTNGP10.phx.gbl...> Try:
>
> If rstPart.Fields.Item("partID").Value < 0 Then ...
>
> Is it a numeric value in the column? Is it possible that it's null?
>
> If CDbl(rstPart.Fields.Item("partID").Value & "") < 0 Then ...
>
> Ray at work
>
> "viktor" <serguienkov@hotmail.com> wrote in message
> news:%23p8uBavnDHA.684@TK2MSFTNGP09.phx.gbl...>> > Hi i am trying to see if the query return some data
> > but i am getting error:(0x80020009)
> > Exception occurred.
> > here is the code:
> >
> > if rstPart("partID")<0 then
> > response.redirect("new_part_no.asp")
> > end if
> >
> > thanks
> >
> >
>
viktor Guest
-
Ray at #4 Re: Check if record set rturn something
Are you trying to check for an empty or null value, or an empty recordset?
If you're trying to check for an empty recordset, do:
If rstPart.EOF Then '''empty recordset
''your redirect
Else
''your code
End If
Ray at work
"viktor" <serguienkov@hotmail.com> wrote in message
news:eAonpgvnDHA.2592@TK2MSFTNGP10.phx.gbl...> what i am trying to do is:
> when user type a part number and this part number doesn't exist to be
> redirect to a diferent page.
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:uxsKabvnDHA.964@TK2MSFTNGP10.phx.gbl...>> > Try:
> >
> > If rstPart.Fields.Item("partID").Value < 0 Then ...
> >
> > Is it a numeric value in the column? Is it possible that it's null?
> >
> > If CDbl(rstPart.Fields.Item("partID").Value & "") < 0 Then ...
> >
> > Ray at work
> >
> > "viktor" <serguienkov@hotmail.com> wrote in message
> > news:%23p8uBavnDHA.684@TK2MSFTNGP09.phx.gbl...> >> > > Hi i am trying to see if the query return some data
> > > but i am getting error:(0x80020009)
> > > Exception occurred.
> > > here is the code:
> > >
> > > if rstPart("partID")<0 then
> > > response.redirect("new_part_no.asp")
> > > end if
> > >
> > > thanks
> > >
> > >
> >
>
Ray at Guest
-
viktor #5 Re: Check if record set rturn something
thanks
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:eL0n3lvnDHA.392@TK2MSFTNGP11.phx.gbl...> Are you trying to check for an empty or null value, or an empty recordset?
> If you're trying to check for an empty recordset, do:
>
> If rstPart.EOF Then '''empty recordset
> ''your redirect
> Else
> ''your code
> End If
>
> Ray at work
>
> "viktor" <serguienkov@hotmail.com> wrote in message
> news:eAonpgvnDHA.2592@TK2MSFTNGP10.phx.gbl...>> > what i am trying to do is:
> > when user type a part number and this part number doesn't exist to be
> > redirect to a diferent page.
> > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> > news:uxsKabvnDHA.964@TK2MSFTNGP10.phx.gbl...> >> > > Try:
> > >
> > > If rstPart.Fields.Item("partID").Value < 0 Then ...
> > >
> > > Is it a numeric value in the column? Is it possible that it's null?
> > >
> > > If CDbl(rstPart.Fields.Item("partID").Value & "") < 0 Then ...
> > >
> > > Ray at work
> > >
> > > "viktor" <serguienkov@hotmail.com> wrote in message
> > > news:%23p8uBavnDHA.684@TK2MSFTNGP09.phx.gbl...
> > > > Hi i am trying to see if the query return some data
> > > > but i am getting error:(0x80020009)
> > > > Exception occurred.
> > > > here is the code:
> > > >
> > > > if rstPart("partID")<0 then
> > > > response.redirect("new_part_no.asp")
> > > > end if
> > > >
> > > > thanks
> > > >
> > > >
> > >
> > >
> >
>
viktor Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
