In ASP, if the ID is empty, how do I set the ID to the default value?

if id="" then

function sjs

dim myvalue

randomize timer 'The action of initializing the random number generator.

myvalue = int((99 * rnd) +1) 'Generate a random value between 1 and 100.

sjs=myvalue

end function

'''''''''Time is converted to ID

dateid=right(year(now())2)myday=right("0"&day(now())2)end if

id =replace(trim(request("id")),"'","")

if not isnumeric(id) or isempty(id) then

It is not recommended that the id be random, and random will not get the desired result, so it is better to jump directly to the error prompt page and refer to NetEase News.

Oh, the id type is made to be automatically sorted, by the way, what database are you using, sql mysql access, and the operation methods are not quite the same.

You can load the method of this page in the controller to assign a default value to the id, and then set it in the view.

This method gets the default value.

Obviously, your xid didn't get the value. You can print it out first and see if it's empty.

I want this asp to default to SongID 1"What do you mean? What defaults?

do while not

if not(shangmen=3 and trim(rs3("songid"))3) then 'The display does not show the dry cover "There is no reed door on the delivery".

Ordinary surface mail. do while not

if not(shangmen=3 and trim(rs3("songid"))3) then 'The display does not show "Home delivery".

The following letter was changed in the same way.

idIf you don't have special requirements, you can use the mountain difference to grow (sqlserver).

Date: You can insert the GetDate() statement to indicate the current date.

Either add a default value to your field in the data doing Weifeng library.

id is generally set to an auto-growth column, as for the date, you can manually insert data in the database, the data type is datetime, or use datetime to get the time, and you can also use this method to cut off the difference and get the string.

Add a judgment after the query.

if id="" or (not isnumeric(id)) then

end if

This paragraph only checks the ID.

To add a steering judgment after the query.

** As follows: %dim rs, sql, id

id=trim("id"))

id=saferequest(id,0)

if id="" or (not isnumeric(id)) then

elseset rs= "")

sql,conn,1,1

if and then"else

end if

end if

It's not a problem here, I think this problem is, id is not empty, but there is no record in the database, the query is empty, you will output, it's the problem there, you have to use one after querying, if not then

output else

No end if is recorded