This topic is locked

asprunner find a record

7/3/2011 8:16:42 AM
ASPRunnerPro General questions
K
kleanthis author

I try to find if a record exist using OwnerID. If it exist to redirect into anther page or to continue with the add page.
That is the code but it seems it does not working. Please help.
'** Check if specific record exists ****

dim rsExists

set dal_table=dal.Table("Address")

dal_table.Param("PMP") = (Session("OwnerID"))

set rsExists = dal_table.Query("T_Kodikas='null'","")

if not rsExists.eof then

Response.Write "record exist"
else

Response.Write "record dont exist"
end if

rsExists.Close : set rsExists = Nothing
'dal.Table("Cars").Value("Make")
' Place event code here.

' Use "Add Action" button to add code snippets.

Sergey Kornilov admin 7/4/2011

The answer greatly depends on what kind of data you have in your database.
You need to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.