(Not sure if this is a bug) I have just noticed the following code in admin_mod_dbsetup.asp in the Createtable sub:
if fdefault <> "" then
select case strDBType
case "access"
if Instr(lcase(strConnString), "jet") then strSql = strSql & "DEFAULT " & fDefault
case else
strSql = strSql & "DEFAULT " & fDefault
end select
end if
This SQL string produced for Access is not different to the string for other databases. Is this a typo or has it been forgotten (to remove? Just wanted to let you know.
Nothing wrong with it, don't forget there are 2 different cases when strDBType is access, and if you are using the *.mdb driver rather than jet, it does not support the DEFAULT directive.
In vbscript 0 = False and anything else is equal to True. So if Instr(lcase(strConnString), "jet") returns 0, it would mean the word 'jet' was not found in strConnString and the line of code would not be executed. If it returned 1, 2, 3, 567,... etc. the statement would be True, meaning it found the starting position of the word 'jet' in the string.
The statement can be written the same way you posted.
It can also be written as: if Instr(lcase(strConnString), "jet") = True then ... if Instr(lcase(strConnString), "jet") <> 0 then ...
Topic Locked
Posted - 08 August 2003 : 08:16:08
