I want to capture the value of variable into a hidden input test field, using the following code.Code:
<input type="hidden" name="selectedby" size="20" value="<%'strNTUser'%>">
When i run the code the variable value is not captured in the field "selectedby". strNTUser is the variable.
What I need to do is parse a string, then create variables for each word. Example:
- someone enters "cats and dogs" in the text field
- I need to end up with:
firstWord = "cats"
secondWord ="and"
thirdWord ="dogs"
Then I will use the variables firstWord, secondWord, thirdWord later in my app.
Have an ASP page on internet, where I let the user write his email address. Today I see that this text input field has got a yellow background instead of the normal white as the other input fields. The code is quite normal. Using IE 6.0.2900. It has not appeared before. Then I rebooted the computer,but got the same result.When I try another computer, also with XP pro and the same IE, the text input is white as it should.
View Replies View RelatedI have a form with an text box called keywords. I want to get the text typed in by the user from this box (which will pobably be built up of several words).
I have declared arrsplitkeywords to assign these words to. But first i have split the input from the text box where there is a space. See the line of code below:
arrsplitkeywords = Split(Request.Form("Keywords"),",")
I now need to replace this so that the words are split up to be split like "','" I have the following line of code to do this:
Replace(arrsplitkeywords,",", "','")
This doesn't appear to work, and on the replace line i get the following error:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
Any help please as to why this isn't working?
i made database with these fields :
id ,name , address ,favo ,email , phone
now i did every thing ok i can add data readdata search by on of any field.
but i do not know how can i search with 3 fields .
i mean i need page include 3 input text one for name
2nd for email , and 3rd for phone . also botton for search
but i want when the user do not input any name or email and click on search botton popup messege come tell you must input all fileds then back to search page . if he input all and click search i want new page read data from database.
I am trying to build an asp page the displays 100 characters from text inputed into a text area. The page keeps breaking because it counts any HTML code the text might have. I would like to have it count the words instead and when I write out the words it includes any underlying html.
For example, here is a sentence: "The fox jumps over the lazy dog" and I could cut this sentence in half by counting out the first 18 character and only outputing those respectively. Everything would work just fine. But if the sentence is like this "The fox jumps <a href='http://www.microsoft.com' target='_blank'>over</a> the lazy dog." a simple letter count no longer works for me. If I printed out the first 18 characters then it will break my "href" tag and therefore would mess up the formatting of my page. Can someone point me to an article or component that will assist me in correcting this?
I want to create some text input fields which they should all have the same size regardless the browser version or type. Because my text input field looks different in size if I view them from a different computer. Is the following coding should solve the problem?
<input type="text" name="field" value="" size="30" style="width:300px;">
Is the best way to use CSS to control the size of a text input field?
how do i allow the user to add in a value that has a ' in it (e.g int'l) apperantly if i do that there will be an error... how do i go about this?
View Replies View Relatedhow do i allow the user to add in a value that has a ' in it (e.g int'l) in the form. apperantly if i do that there will be an error... how do i go about this?
View Replies View RelatedI'm using Access Database with ASP. There is one particular thing that I
have issue with.
My purpose is for user to update their own profile. Their existing profile
information will be display in Edit Form format. The problem is if the field
has space, the second word will not display, when I display in input text
format.
E.g if My first name "User_FirstName" in my table has entry, let say "David
Johnson" as FirstName, when I execute following code and do a input text, it
will display "David" only. Code:
I want to change the text color of the input box depending on the value entered by user.
View Replies View RelatedThis problem only occur when ppl using NetScape 7.2 I've tested it myself and it works in IE and it DOESN"T work in NetScape 7.2 Here is the code:
View Replies View RelatedI have a website with a Guessbook section. Lately I noticed someone copy and pasted a long http address to promote viagra.. I believe he simply copy and paste the whole link into the text input field and submit several times. It created multiple entries in my guessbook.
How can I prevent this? I was thinking if it is possible for me to write some code to disable people using the control-p to paste text in my text input field.. Can I really do that? What other options do I have?
I want to have a user input a value (1 through 10) in a form. Then click submit. and right under that have text appear depending on what they input. This is what I have, but it doesn't work. I'm not understanding the flow of the script getting called. Code:
View Replies View RelatedIsn't there some line of code that I can write to tell ASP to treat everything between BLAH and /BLAH as text (including the apostrophe). So that users can type a name of "O'Malley" in a form and I can retrieve it and store it in my database.
View Replies View RelatedI am currently making a form in asp and when i make the text boxes they are all formatted to the same size, even if I use the width=*** to change the size? Is there another way to make the input text boxes smaller or bigger?
View Replies View RelatedI'm having a very difficult time with an ASP page that I develpoped in Dreamweaver and the MS Access DB it's supposed to update. When I submit the data the following error appears:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/sessiondata2.asp, line 115
I know this is usually a reserved word issue but I don't think that's the case here because the page updates perfectly when executed on my computer as a testing server.
The rest of the site updates data into the database properly so I know the connection string is working. I can't figure out what would throw an error on a live server when there isn't one on a testing server. Code:
I'm using the detailsview to perform edit and insert of new records via an
object datasource.
If an error occurs on the insert, I want to preserve the data the operator
tried to input, along with my error messages. Currently, it appears that the
detailsview is trying to rebind after the error, to the empty/null detail
item(on insert it is null), and thus I lose all the operator's input. Can
someone suggest the proper way for me to achieve the persistence I'm looking
for?
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
I have this insert statement where instruction field in the DB is a memo field.
SQL="INSERT INTO int ([instruction]) VALUES " & _
"('"&Request.Form("myTextarea")&"')"
objConn.Execute(SQL)
Its giving me error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Im trying to use a sesson statement within an SQL Statement:
sql = "SELECT * FROM tblNumbers WHERE AllocatedTo=" & Session("Company") &
""
And get the error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/numberlist.asp, line 31
Anyone got any ideas? Surely this can only be something basic?
I am trying to create a simple library system to document all our resources. Here is the
Code:
Dim cc As Currency
Microsoft VBScript compilation error '800a0401'
Expected end of statement
process.asp, line 33
Dim cc As Currency
-------^
I am doing something wrong here. How should this be coded?
I am trying to select all records from a table, however the table name I want to be a variable. I tried to do the following (code below), but it does not work. Any ideas on how to use a variable as part of a table name?
tableName = Request.Form("tableName")
tableName = REPLACE(tableName,"%20"," ")
set objConn=Server.CreateObject("ADODB.Connection")
objConn.Provider="Microsoft.Jet.OLEDB.4.0"
objConn.Open(Server.Mappath("db2/email.mdb"))
SET rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM" & tableName, objConn
Find below the error I get when the code below is executed
Code:
splitval = split(request.form("start")," ")
dep = splitval(0)
splitval1 = split(request.form("end")," ")
dep1 = splitval1(0)
"SELECT * FROM Info WHERE requestDate BETWEEN dep AND dep1 "
error:
No value given for one or more required parameters.
Can someone help correct the error in the code.
I am getting a syntax error on my SQL statement, not sure if I am doing this
right. i am trying to pass a value from another form.
strsql = "select PrinterModel, PrinterName, IP_Address, Location from
Printers where PrinterName = ' & <% =Request.Form(npName) %> & ')"
I am trying to run a simple update statement through asp and for the life of me can't figure out why it isn't working. I was wondering if anyone could look at this and tell me what may be wrong: Code:
View Replies View RelatedI need the end statement to this sql query, but I am doing something wrong, is there site where they show you the different forms of ending sql statments in ASP? Code:
View Replies View Relatedwhen i execute any "Insert..." sql,i get this error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
can any one show me how to solve?
i have this error on the regisration page of the website i'm doing.
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Shop/register_process_corp.asp, line 40
SQL = "INSERT INTO
------------------^
Code:
The block of code below shows how I am inserting field values into my dbase table:
strSQLStatement = "INSERT INTO tblArticles
(handid,ArticleDate,sport,articleheader, fpick,articleText) "_
& "SELECT '" & handid & "' As handid, '" _
& ArticleDate & "' As ArticleDate, '" _
& sport & " As sport, " _
& articleheader & "' As articleheader, '" _
& fpick & "' As fpick, '" _
& articleText & "' As articleText;"
Conn.Execute(strSQLStatement)
but I am getting an "Insert statement contains fewer items than the insert list" error , when in fact I am not (both 6 field names).
I got the following line in the formatcurrency statement that is giving error.
Response.write "<TD ALIGN=RIGHT WIDTH='10%' >" &
FormatCurrency(TotPersonnel) & "</TD>" & vbCRLF
The error message is: Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'formatcurrency'
/gwisprod/FSR_EditDetailPrint.asp, line 345
I found out that if TotPersonnel field contains null value, the above error gets generated.
i going to execute this sql statement...and the error come up.. why?
Select * From members Where ID = '123'
pls note that the type of ID is autonumber
is it becoz of type of ID is autonumber? how to solve this problem??