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:
I've never worked with ASP, and was thrown into this major problem... I'm trying to perform an INSERT query into an SQL Server database. The query returns an error dealing with the date. The query is being inserted as: Code:
View Replies View RelatedI 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.
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
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 am using the following code to to insert into db a field :
insert2SQL = "INSERT INTO Clients (CliName) VALUES ('" & PAY1_CHNAME & "')"
objconn.Execute(insert2SQL)
and I obtain the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Tinjaca' Ramirez Luz')'.
/gestpay-otp/test/s2s.asp, line 111
because the client has inserted a name with apostrophe, this the data that was received for this field: Code:
I am pulling data from a table to create a <select> list. I need to wrap the value= in double quotes. Code:
View Replies View RelatedI have a form online, and I don't know if people are double clicking the submit button or what is happening really, but sometimes I will have two or more matching entries in a row. Is there any code I can use to filter out double clicks or tripple clicks even? These forms are done in asp and sent to sendcontactform.asp to process.
View Replies View Relatedhow can I double split this string and pu the values into an array?
string = 2_3, 4_5, 6_8;6_9, 4_6; 3_1
I need the split after "," and ";"
I have an asp page.I have all the form tags, javascripts etc in that. For e.g In my asp page I have mentioned my form tag as
<form name=frmupdateskill method=post>
and javascript as
<script language=javascript>
some code...
</script>
I send this asp page to my onsite person. When he replaces the old asp page with the one I sent the following are the things I come across. Code:
I am using an HTML form to post data to my database, but when a users enter contact info into my database I am getting the same info twice, although the user only submits once. Here is my code:
sSQL = "INSERT INTO Lead_Data (username)" & _
"VALUES ('" & User_Name & "')"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=", "", ""
objConn.Execute(sSql)
objConn.Close
Set objConn = Nothing
Response.Redirect("addpass.htm")
I'm trying to pass data from a <textarea> box to a confirmation page and then pass the same information from the confirmation page to a final page.
When the information gets passed to the final page it is truncating it where there are double quotes. I've tried to do a replace() function to try and escape the quotes out but it's not working.
confirmation page
Code:
<input type="hidden" name="results" value="<%=results%>" />
final page
Code:
results = request.form("results")
results = replace(results,""","""")
results = replace(results,vbcrlf,"<br />")
What I would like to do is the following: Menu box 1 populates all 50 states from an SQL table. Use selects State. Menu box 2 gets populated from SQL table with Al counties in that State. User selects prefered county then hits submit The part I am having trouble with is populating the county menu box.
View Replies View RelatedI have a active server page where records are displayed from a query. The
display right now is read only. However, with text box this display can also
be edited. The first column shows category while the second category shows
category total sales.
I would like to double click on category field to get
to another asp page that would show the details of sales for that category
value double clicked.
My question is: If there is any double click event that would allow me to
pass values to open another asp page.
I have an order form that dynamically populates item names and item ids from my MS SQL database. These values get put into three arrays that are looped based on the qty selected for insert into a cart table. Everything works except that the values are inserted into the database twice. Here's the insert code:
View Replies View RelatedGot a stubborn problem with double quotes
i can replace two single quotes but how do i replace a quotation mark e.g. (") and not ('')
Replace(rstSimple3.Fields("Description"), "''", " ") works
Replace(rstSimple3.Fields("Description"), """, " ") cuases error!
i want to know how to include double quotes in " "
such as
somevariable=" "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("kb.mdb")" "
note this is example given by me.
i only want to know that
how to include double quotes within double quotes.
I got to place a loop to create a call to javascript with different ID' s generated by asp like in the following code ...
View Replies View RelatedI need to output a string with double qoute ex. "$5.24" using asp and vb script. Greatly appreciate for any assistant.
View Replies View RelatedI am going to use the date as my filename. How can I convert date() ["5/18/04"] to "20040518"? Thanks a thousand.
View Replies View Relatedconverting a single
digit (ie: 1, 2, 3, etc) to double digits (ie: 01, 02, 03, etc).
I am trying to convert the date in DD/MM/YYYY format so it is always displayed as 01/01/2004 instead of 1/1/2004.The script I am trying to embed this into has similar attributes to the Calendar on this site located at http://www.asp101.com/samples/calendar.asp.and the objects that require to be double digits are iCurrent and Month(dDate).
I have some data string like ~!@#$%'^&(*("}[;asd"> which contains double quote and greater then sign, first I need to insert this value into database, second this inserted value I have display in a textbox by retriving from database, as it has "> at end of the string values are getting discarded.
View Replies View RelatedIf rs("MyString") is Hello "Jim" Lad
<input type=text value="<%=rs("MyString")%>">
prints as <input type=text value=" Hello "Jim" Lad">
How can I get double quotes to display in a text box or textarea? Using a backslash or &Quot; (with Replace() e.g.) just prints out the backslash or &Quot;
Here's an example of using ASP, CDO and a Microsoft Access database to create a double opt in mailing list for subscribers. It lets the user subscribe and then sends them a confirmation email with a random url that has to be clicked to confirm the subscription.
I had a hard time finding a free example so I threw this together for other's searching for something to start their own with.
If user refreshes the browser window, or if user clicks twice onto the submit button, SQL query is executed twice, the table gets two new rows.I found many possible solutions, but not the complete one - every solution has it's problems.
View Replies View RelatedWhen you want to put double quotes inside a string, how do you verify that the double quotes are not the end to a string? For example, what if you want to write this. Code:
"Response.Write("The words "DEV SHED FORUMS" are in double quotes")
Here's the line I need to insert into an ASP page.
<script Language="JavaScript" src="/blarg.js"></script></head>
Right now it throws off the asp include with the quotes.
I have created an Intranet in my office using ASP (of course). Within it is a booking system, allowing booking of conference rooms, digital camera and other equipment. It works perfectly...almost, as there is no way to prevent double bookings.
I really don't know where to begin with this one. All bookings go to an Access DB, into a single table. The bookings have a start time and an end time (24hr).
I would like it so that when the user submits the form, if there is a clash in times instead of saying, thanks for your booking, to redirect them back to the booking page saying there is already a booking for this time and that I am very sorry!
I guess I have to check some value in access and return the info back to the webpage before it chooses where to redirect the user.
I've got a form which lets users input HTML code into a database (the user enters their code into a form field, then submits, and the HTML is written to a db). This code is then pulled out of the database onto a web page. It must validate - so needs to have all characters intact.
How do I perform an update statement which lets me insert double quotes into the database? I know it's possible to achieve a similar thing by replacing the double quotes with some other characters on insert, then replacing these other characters with double quotes when the data is pulled out of the db, but this seems a bit messy.
Some basics to check, does this happen on all machines that submit, or only one. If it is only one, then chances are it has to do with mouse settings on that machine (i.e. double click speed type of thing).
Try checking and submitting on another machine. If it only happens on one machine, try changing the mouse settings on the original machine. Try submitting on the original machine. If this doesn't work, then worry about programming around the event.