asp-classic
I'm new to classic asp, all my experience is in c# .net and ColdFusion and php.
Anyway, this site I'm working on has this code all over the place
If (CInt("0" & myVar) > 0) Then
myNewCar = CInt("0" & myVar)
End If
What I don't understand is why the "0" is append to the var in the cint() input? Am I just missing something? Is it some kind of safety thing? Is it efficient?
On a side note, any classic asp books recommended?
Big edit: I was pointed by @EdSF in the comments that the answer was wrong. In disbelief I checked using Firebug, and, in fact, it was wrong.
You need to use Context.Response.RedirectLocation for the status code to work.
I'm doing the same in global.asax:
Sub Application_BeginRequest(ByVal sender As Object, ByVal e As System.EventArgs)
Dim fullOriginalpath As String = Request.Url.ToString.ToLower
If (fullOriginalpath.Contains("/verarticulo.asp?articuloid=")) Then
Context.Response.StatusCode = 301
''// this does not work, returns a 302
''//Context.Response.Redirect("/noticias/" + getIDFromPath(fullOriginalpath))
''// this does right way
Context.Response.RedirectLocation = "/noticias/" + getIDFromPath(fullOriginalpath)
Context.Response.End()
ElseIf (fullOriginalpath.Contains("/archivo.asp")) Then
Context.Response.StatusCode = 301
Context.Response.RedirectLocation = "/archivo/"
Context.Response.End()
ElseIf (fullOriginalpath.EndsWith("/default.asp")) Then
Context.Response.StatusCode = 301
Context.Response.RedirectLocation = "/"
Context.Response.End()
End If
End Sub
The only thing you have to do if you are using II6 you have to configure this ISAPI filter in this way:
The file is c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll
You can assign the the users to a GROUP and assign the relevant permits (using GRANT) to the group. When connecting to Ingres, I assume via ODBC, you provide the GROUP name as part of the connection string. Whilst you still have to assign users to a GROUP the overall performance will be better when accessing the table.
I think you should be able to add a group to your connection string using:
DSN=data_source_name;GROUP=mygroup
For the complete list of DSN attributes see http://docs.ingres.com/Ingres/9.3/Connectivity%20Guide/connectstringkeywords.htm.
Best Answer
Its an old hack to handle null values. Calling CInt on a null would result in an error. However concatenating a string with a null results in the string hence "0" & null returns "0". This prevents CInt from erroring when the value is null.