Urgent, Sending Date From Textbox?
I created a database in MS SQL 7.0 called "DBSupply".It has a table called "product".
The table has two columns Named "DateSupplied" and "productSuppiled".
On my Supply.aspx page, I have a textbox, Search botton and a datagrid.
how do i construct my sql query on the supply.aspx page so that when i type a specific date(e.g 2/2/2005) and click search botton. in the textbox it will display date and the productsupplied on that date on my datagird.
I dont know which SQL query to pass from the web page, that will help me retrieve information from the database based on the data i type in textbox.
I am using a Text Editor(Note Pad) and VB as language.
View Replies
ADVERTISEMENT
<%
If request.Form("send").count > 0 then
set objMessage = CreateObject("CDO.Message")
objMessage.Subject = Request.Form("sub")
objMessage.Sender= request.Form("from")
objMessage.To="myemail@hotmail.com"
objMessage.TextBody=request.Form("msg")
objMessage.Send
response.Redirect("contactus.asp")
end if
%>
I'm suppose to allow users to send feedback to myemail@hotmail.com using a webpage. So i've used this asp code. But it seems like the code doesnt work for me. I've tried the page out, and there was no email sent to that address.
View Replies
View Related
I have an input type text in my 1st asp page....when i go to the 2nd asp page i want to retrieve my textbox value in my previous page...i know how to do this with a form...i want to do it in another way, is that possible?
View Replies
View Related
I have data from page 1 that I want to pass to page 2, either in a querystring or a form. I got that part.
Once I'm on page 2, I can retrieve that data with Response.Form or Reponse.Querystring in the vbscript code I have up in the header, but if I write
Document.Form1.Textbox1.value=response.form("passedData"), nothing happens.
So I thought that the code up in the header doesn't "see" the textbox, because as I dimly understand it, the textbox is client-side and the script is server-side. So then I thought I should put the same line down in the html where the form is defined (enclosed in <% tags). But that triggers an error because the code down there doesn't seem to know what response.form is anymore! I tried using a variable as a go-between, but it didn't change the results.
So how in the world do I get my incoming parameter (whether form or query string) to go and live in a textbox in the target page? I need it there (don't I?) so that I can later pass it along to page three (among other reasons).
In short, I can get strings passed from page 1 to page 2, but then page 2 doesn't seem able to put them into controls or pass them along to page 3.
I have scoured google and forums and seen some responses that involve about 30 lines of code (which I don't understand). Surely it can't be that complicated to pass a string from page 1 to page 2 and then have it available to pass along to page 3.
View Replies
View Related
I need to put a date function into a textbox. The function is <%=date>
View Replies
View Related
Windows 2003 Server. IIS 6.0
Website is running in separate application pool.
I keep getting timeout problem. and the CPU is max 25%. The calculation runs
more than 15 minutes. I tried to check CPU monitoring option for the
application pool and I set to MAX 100% CPU usage. It didn't help. CPU is
still 25%. I didn't restart the server though. There is no time to rewrite
the code to improve performance.
View Replies
View Related
i have created asp pages and inserted the table which width is 100% percent but when and visit that page the width of page is less then 100% but if i refresh the same page then is shows 100%.i have included one file as header. it is because of that or what.
View Replies
View Related
I am new to asp and therfore not sure that I know one of the most basic things, to trap errors on my web site
I have two fields where I enter any character from a keyboard and it saves every single one but the + SIGN,just puts in a space instead.
I am "escape" ing and "unescape" ing but the + sign still doens't get saved.
How can see what is going on and could you please explain how to degub it as I don't know myself.
View Replies
View Related
i have tried to look for all errors and referred to all my frends work with regards to this 'shopping cart' problem
i wan to add an item into the shopping cart but the database recognizes the adding and generates a new id . but the shopping cart item database doesn't have any reaction.
i have review and checked for all typing errors or the likes but i found nothing.
View Replies
View Related
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
View Replies
View Related
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>
View Replies
View Related
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
View Replies
View Related
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"/>
View Replies
View Related
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 Related
i 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
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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 Related
anyone have any idea how to do checkbox with textbox beside.
View Replies
View Related
I 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.
View Replies
View Related
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">
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
can anyone send me the code for prepopulating for the textbox?
View Replies
View Related
I'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?
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
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 Related
I'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?
View Replies
View Related
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?
View Replies
View Related
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"....
View Replies
View Related
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
