Recommended: Asp prompt invalid use of Null: Replace Use REPLACE to replace the data read in the database. It is normal if the field is not empty, but if it is empty, the following prompt appears: Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'Replace' The main problem is that the field of SQLserver is null, so it cannot be simply null judgment. You can only use isnull to judge if first
Asp Upload image prompts ADODB.Stream error '800a0bbc'
There are many problems with this prompt. Permissions are common. Not to mention this, there is another strange thing
The format of the system time of Windows 2008 displays is: 2013/3/8, not the previous 2013-3-8. Since the renamed and uploaded files are named by time, this requirement is 201338, but on the Windows 2008 platform, it finally became 2013/3/8. This will have a problem, that is, it will be solved as a folder and a path, which will eventually lead to a real non-existent directory and an error in writing.
Solution:
After viewing, there is a paragraph of content in the upload and save file:
. . . . . . . . . .
set file=upload.file(file1)
if file.fileSize>0 then
'Automatically generate file names
filename=date()
filename=filename&time()
filename=replace(filename,/,) (This was added later, after adding this sentence, the uploading of the picture was successful)
filename=replace(filename,-,)
filename=replace(filename,:,)
filename=replace(filename, ,)
filename=filename+.
filenameend=file.filename
filenameend=split(filenameend,.)
. . . . . . . . . . . . .
filename=replace(filename,/,) (This was added later, after adding this sentence, the uploading of the picture was successful)
It means to replace / with empty
The problem has been dealt with.
Share: Use Tong ASP to directly obtain the user's real IP address General FUNCTION, if the real IP cannot be obtained, it will replace the proxy IP Private Function getIP() Dim strIPAddr If Request.ServerVariables(HTTP_X_FORWARDED_FOR) = OR InStr(Request.ServerVariables(HTTP_X_FORWARDED_FOR), unknown) 0 Then strIPAddr = Request.ServerVariables(REMOTE