I am using the recordset below but I only want to inner join fixtures on teams if Fixtures.HomeTeamID is a numeric value, how could I do this? Code:
Dim rsHomeT
SET rsHomeT = Server.CreateObject("ADODB.Recordset")
rsHomeT.Open "SELECT * FROM Fixtures INNER JOIN Teams ON Fixtures.HomeTeamID = Teams.TeamID WHERE Fixtures.LeagueID = " & ID & " ORDER BY iYear, iMonth, iDay ASC;", objConn
I am using an import process that scans an html file and exports data toa sql database table.One of the fields I import, on occasion has 2 numeric characters at the
very end. For example "thename 04".What I need to do is delete those numeric characters, if they exist.I thought about something like this:
if isnumeric(right(thename,2))=TRUE then
but what's next? How do I make a new THENAME field without those last two numeric characters if they exist?
if Shift = "" Then
error_list.add "589343","desired shift must be specified."
b_error = true
end If
for this function, how can i implement isNumeric to get an error msg for the user so tell them not to key in char but to enter only INT.
In my asp page (which I am using VBScript for)....if I use the IsNumeric(x) function, will this only evaluate true for integers x??? Or will it also evaluate to being true if x contains a decimal point????
View Replies View RelatedI wrote a stored procedure to INSERT a new row in the database. It returns the new ID via @@IDENTITY. This value is read by my ASP and stored in variable intNewID. The value displays fine via <%= intNewID %>. But when I tested it using IsNumeric(intNewID), it returned False.
View Replies View Relatedwhy does isnumeric return true?
a=""
if isnumeric(a) then
response.write("test")
end if
empty isnt numerical is it?
I have received the following feedback for the two functions bellow:
"The ISNUMERIC test is WORTHLESS for checking for an INT value, because
ISNUMERIC will happily accept DOUBLE values, such as 89.11998811777 and
other values that are simply *NOT* INT values." Code: