I want to alter the text displayed in one textbox depending on the value input into another textbox. For example, when entering a customer code into the first box, I want to display the customer name in a second textbox. This will have to be done more than once on a form.
View RepliesI am trying to change the data type of one of the columns in my SQL table remotely (via ASP scrpit). I understand that ALTER TABLE will allow me to drop and add columns, but I can't find any information on ways to alter the data types.
View Replies View RelatedI have a web form that submits data to an email box. I would like it to only send those fields that had input and not the zeros. how to alter my script.
View Replies View RelatedHow can I change a column in my database so it becomes auto_increment? Something like,
ALTER TABLE Article
ALTER COLUMN Id autoincrement
if I add <% Server.ScriptTimeout = 300 %> to a page, does that then alter
the default 90 second script timeout for ALL pages (if so, is it for that
session or until??) or does it just alter the timeout for THAT individual
page?I've been through the IIS docs and I haven't been able to find the
definitive answer.
I would like to store a table of alternate URL's it would work like this - in my forums, a user may add a URL (for example www.hyperlink.com). When another user would click on this URL, I would like to call the alternate URL table to see if an entry exists for the domain "hyperlink.com" If so, I would like to alter the hyperlink (on click) to "www.hyperlink.com/123/test.asp" If the URL is not listed in the alternate URL table then I would like it to go to it's original target address.
View Replies View RelatedALTER TABLE Sales ADD COLUMN UnitPrice CURRENCY;
does this command allow for overwriting (or skipping) the column if it already exists? The reason I'm asking is because the file that I'm reading in will contain the column and the value associated with the column.
However, some files may or may not contain certain columns, thus if it doesn't exist I have to create a new one, or I need to add to it.
I have an Access table with some fields set as text and I would like to convert them to integer.
For some reason some values have wrongly been entered with chars, thus
ALTER TABLE my_table ALTER COLUMN my_field Integer
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
If I manually convert the field using Access, I get warned of possible data loss, but the conversion takes place anyway.
How can I force the conversion using just SQL? Is there something like an option "override errors" / "force conversion"?
does anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
View Replies View RelatedcmdTemp.CommandText = "Select * From users"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rstContacts.Open cmdTemp, , 1, 3
rstContacts.Move CLng(Request("Record"))
i only want this command to display from the users table the details
of the user that has the username (from the database) equal to the username of the person who has just logged in from my login form (uname input box) this code at the moment displays the first record, i dont want that.
I have a text box but I want to insert the max number in a text box. Here's the code I have for selecting the max record:
<%
objconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("calibration2.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open objconn
set rsEmps = conn.Execute("select Max(recordNumber) from CalibrationRecord")
%>
How do I put it into a textbox? Here's the code for the textbox:
<td width="34%"><INPUT NAME="RefNum" TYPE="text" id="RefNum" VALUE="<% response.write RSEmp("recordNumber") %>" SIZE=25 MAXLENGTH=50 ></td>
textfield from form1 is called SID
primary key in database is called "School ID"
i tried
Code:
SELECT * FROM Schools WHERE "School ID" IS form1.SID
but errors out
---error---
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/tp/display.asp, line 37
I am using a textbox with in a forloop, for each time when i click a button
it genarates a new textbox, so for example for first time there will be 1
textbox, i will enter some value into that textbox and i click the button
which adds another textbox and i enter someother value and i go on clicking
for to add a new textbox and enters some value. after creating 5 textboxes i
want to know the index of the textbox, basing on thet index i will find the
value and do some calculations and some more. so i must compulsorily need
index of the textbox.
SO can any one help me.
when i see in the view source i am seeing that 5 textboxes names are same.
<input type="text" name="txtStores" id="txtStores" value="0" size="4"/>
<input type="text" name="txtStores" id="txtStores" value="0" size="4"/>
I've got a textbox (within a form) which is blank. How can I program a button that will make a value appear in the textbox without refreshing the page??
View Replies View Relatedi have 3 text box,in that one gets value from a picklist these three values have to be displayed down in table format and every time the page gets refreshed when a new product is selected using the picklist
for example
product :
rate :
Quantity :
table
~~~
_________________________________
|s.no | product|rate|quantity|amount|
--------------------------------------
1 adb 23 2 46
2 xcv 25 2 50
i need to display like above for n products
how to display 2 values inputted on a textbox and transfer it to another asp file? below is my code
enter.asp
<form method="get" action="names.asp">
enter name :
<input type="text" name="xname">
<input type=submit>
names.asp
Response.Write("<input type=text name=frm_name value=" & Request.QueryString("xname")& "><br>")
what happens is when im in enter.asp and i typed in for example Michael Jordan it goes automatically to names.asp but what happens is when it goes to the textbox of names.asp it would only display the word Michael.
I'm modifying an existing ASP app. I'm quite used to ASP.NET but have never worked with classic ASP before. I'd like to know how could I set the value of a textbox to the selected text of a combo on client side ? It has to be done every time the page is loaded because the combo is hidden.
I know I'd be better using server-side, but I can't modify too much things on that side, and I donno how to set the value of a control on the server side.... I miss the good ol' 'runat="server"' from .NET
I have 2 textboxes on one page. How can I get the value of one textbox (key in by user) and display the value of that textbox to another textbox?
View Replies View Relatedanyone have any idea how to do checkbox with textbox beside.
View Replies View RelatedI have seen some techniques like this on the web. Currently, I'm using Combo
box which values came from database table. One disadvantage is when the
combo box have lots of values, users are complaining since you cannot use
keyboard to search the value that is needed.
How do I make a textbox invisible so that i may add code that i dont want the users to see and pass it along?
<input type="text" value="<%=email%>" name="T1" size="20">
I was wondering how to make a text area that allows the input of html tags or custom tags for fomatting of text.
Actually almost exactly like the textbox we use to post to this forum. I would only need text formating like bold maybe colors of fonts alignment etc. I can't seem to find anything that teaches people how to do this.
Im doing a code in asp.
I dont know how to format the textbox in a way that when the user enter the number the format must be for sample:
612-947-4320
Or a date format sample:
02/11/05
i have a shopping cart type system where a user adds items to their cart, and as they are doing this, i have a textbox for the user to enter the quantity of the selected item they want!i want this textbox to be max. 3 characters in length (for asthetic purposes!!) but no matter waht width i make it, it is always displayed much bigger(longer) than i want! So how do i force this
textbox to be no more than 3 characters in length?
can anyone send me the code for prepopulating for the textbox?
View Replies View RelatedI'm wondering if it's possible to search words from a huge text instead of one or two words. Example:
If the actual text says:
Quote:
I'm walking the dog tonight. The dog is hungry.
Is it possible to search "walking" and "hungry" from one textbox or textarea?
I would like to know if this is possible. I'm using ASP with JSCRIPT.
I have a dropdown box that when the use selects a particular value, I would
like the textbox to become visible.
also if they dont choose it, I would like the textbox to be hidden.
I have this web input form with many other fields. This dropdown box is in
the middle of these fields.I dont see any property to set. I see the disable property but I want it
hidden.
I have a requirement like this.When the textbox gets focus..at this even i want to change the input langauge settings.like arabic.
Currently i have to do it manually by pressing the Alt+Shift key..to toggle between twon langauages
I have a form that has a dropdown list. I would like to have a textbox be displayed after the user chooses "other". How can I do this? I would also like the field to go away when the user chances their mind. Is this possible?
View Replies View RelatedI'm wondering if it's possible to search words from a huge text instead of one or two words. Example: If the actual text says:
I'm walking the dog tonight. The dog is hungry. Is it possible to search "walking" and "hungry" from one textbox or textarea?
it's possible to search words from a huge text instead of one or two words. Example:If the actual text says:Quote:
I'm walking the dog tonight. The dog is hungry.Is it possible to search "walking" and "hungry" from one textbox or textarea?
First Question:
When I try the fallowing I get an error message:
Field1 = Replace(Field1, """, "& quote")
Second Question:
I have some info stored on Access DB, when i pull it for updates I should print the data as fallow:
<input type="text" name="Field1" value="<%= RS ("Field1") %>" size="20">
All that well and good but the problem occur when "RS ("Field1")" contain a double quote!
Let's say I have:
RS ("Field1") = Hi "guys"....
how to develop a form where we can enter text and also paste a picture?how can we take unlimited matter in a text box?wat data type should we use?
View Replies View Related