Input Fields Blank Space
I have entries in the database that have spaces (Todd's Place) but when I try to get the info into an input box it only shows the first part of the string before the space (Todd's) Here is my code
strSQL = "SELECT ID, memname FROM tblMembers WHERE ID =" & numID
Set rsEdit = adoCon.Execute (strSQL)
<input type=text value=<%= rsEdit.Fields("memname").Value %>>
The funny thing is I can see the whole string when I view the source on the page (<input type=text value=Todd's Place>) but why can't I see it in the form.
View Replies
ADVERTISEMENT
I retrieved some data from the database and put it in a textbox but the words after the blank sapace cannot be shown, why is that?
Name = rs("requestor") 'where the name is "Sam Siew"
<TD><INPUT TYPE=TEXT Name=requestor size=12 Value=<%=Name%>></TD>
In the text box, it only show "Sam".
View Replies
View Related
When rs("firstname") is called on my page,
it returns the first name and a blank space before it.
I want to pass it throught the QueryString,
but URL's can't have blank spaces.
On my DB (Access), the none of the firstnames have any spaces in front of them.
Any ideas?
View Replies
View Related
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:
View Replies
View Related
i have created a database system for work but when you input job details you have to fill in every box i want it to be able to process and add the data to the database without having to have every box filled in. Here is the code:
View Replies
View Related
I'm working on a form where the user is not required to fill out every text input. How mught I check for that in an ASP script. Here's what I have:
If Request.Form("mp3title1") == ""
amnt = 0;
Else If Request.Form("mp3title2") == ""
amnt = 1;
Else If Request.Form("mp3title3") == ""
amnt = 2;
Else If Request.Form("mp3title4") == ""
amnt = 3;
Else If Request.Form("mp3title5") == ""
amnt = 4;
End If
Pretty straight forward, its checking in order if the first element is left blank, is the correct technique:
== "", or is there more to it?
View Replies
View Related
All my fields give that error when I try to leave it blank when inserting a new record. The field is not required in the database, so what do I have to do to insert it as blank?
SQL:
Code:
INSERT INTO Tablename (REQUIRED, NOTREQUIRED) VALUES ('tag', '')
Error:
Code:
[Microsoft][ODBC Microsoft Access Driver] Field 'Tablename.NOTREQUIRED' cannot be a zero-length string.
View Replies
View Related
I am writing an application which when the code first loads there is a form which all the fields are blank. I then need to test some date fields to check if the end date is before the start date etc. The form fails to work. So I then wrote a test asp page which has a single box I then use an If...
Else statement if it is Blank then do nothing if it has data in the text box then display a message. The form works ok until I input text and then it does not detect any input text in it and therefore does not display the message. This is totally the oppoisite of the original application which does not detect the form is empty. Code:
View Replies
View Related
I'm using ASP FormMail to collect user info, but now I'm trying to figure out how to modify the code so that any blank fields from the form will not be displayed on the confirmation page/email. I tried to modify the code below in bold, but it gave me a syntax error. Code:
View Replies
View Related
I have created a database were you submit a job by entering the fields which is fine if it is a site visit but if it is a phone call or remote help not all the fields need to be filled in but if there not filled in it wont submit the values to the database i get data mismatch error code is below.
I either need to be able to send them blank values to the database or ideally i wont to create a option box with Phone call, Site visit and remote help which when selected takes you to the correct page which have different values in the form to fill in.
View Replies
View Related
I've written an ASP page that pulls all records from a table. My query
is 'SELECT * FROM teacher ORDER by Class'
It is working fine... sorta. The table has about 20 records, but only
5 have an entry in the 'Class' field. The 15 records with the blank
class field show up first, then the other 5 records. Is it possible to
have the blank one show after the ones with an entry. Here's how my
results look, IOW. Code:
View Replies
View Related
I created a feedback form for my website that has only 2 required fields. When you submit the form it calls my asp page which puts the information in a database and then sends me n email with the information that was entered into the form. The problem is that the form only has two required fileds, and if the remaining non required fields are left empty when the asp page is called it does write to the data base, but does not send me any email. However if I go back in and put somethng in every field in the form then when I submit the form and my asp page is called it writes to the data base and sends me an email with the all the information I entered in the feedback form. Is there a way to tell my asp page that it is ok to send the email even if the non required fields are left empty? I really do not want to have to go back through the form and put default values in for each area of the form? Also is there a way to have an error displayed if the email is not sent? My asp code is below....
View Replies
View Related
I have a .asp form page that submits to another .asp page that uses cdonts to send me an email and does a response.redirect back to the form page. I need to preserve (keep) a couple of text box values and a couple of dropdown box values.
At this point I have global.asa variables for the fields in question and they are all set to null. I can't figure out how to put the contents back in the fields, when it returns from the cdonts page. I assume that I must save all the field values in the session variables just prior to the submit to the cdonts page.
show me how to accomplich this for one text field called name and one dropdown box called PUDeliv?
View Replies
View Related
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
View Replies
View Related
I would like to exclude 2 or three input textboxes (hidden ones) from being
included when I click the "submit" button on a form.
View Replies
View Related
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
View Replies
View Related
i have a form where a user will enter their information.... i know how to check if the user didn't enter a value so that they are not redirected to the next page but how to check if the user pressed space and not allow that space character to be a valid character?
View Replies
View Related
I have a webpage with some hyperlink within a button. The problem is that some of my hyperlink is shorter that others and therefore the user must navigate to the hyperlink to click on the link
The thing I want is to make the button more user-friendly user can click anywhere on the button and not only on the hyperlink within the button
Here is my code ....
View Replies
View Related
In an ASP Page is there a way to have a link that calls another page whose name includes a space? For example, I'd like to be able to call "My Page.asp" by building a href type link the user can click on. The equivalent of:
<a href="My Page.asp"> Open </a> the page
I've tried URLEncode but that didn't work.
View Replies
View Related
I’m reading a list of values from a database table a creating a dropdown list on a web page. These are used as search criteria to search on a second table. The user selects and item from a list and then clicks a button to submit the search. All of that works.
Most search words in the list are a single word with no spaces. Some are two words. When that is passed, anything passed second space gets lopped off. Here is the line of code that creates the dropdown box
sDataSet = rs1("Dataset")
response.write "<OPTION selected value=" & sDataSet & ">" & sDataSet
I tried this, but it didn’t work
response.write "<OPTION selected value=" & Replace(sDataSet, “ “, “%20”) & ">" & sDataSet
It replaced the space with %20, and the entire search phrase was passed, but the search failed because the %20 was not converted to a space on the other end. So now I doing the conversion myself after I do the Request.Form. Is there a better way though, to deal with spaces.
View Replies
View Related
My form gets populated from an access database. Now in the database there are fields containg <br>. While in a normal page everything works as it's supposed to, in my listbox the <br> shows as it is. What I would like to do is replace it with a space so I've used this:
<option value="<%=(rsProducts.Fields.Item("CatNum").Value)%>"><%=replace(rsProducts.Fi elds.Item("NotesR").Value),"<BR>"," "%></option>
but it doesn't seem to work.
What exactly am I doing wrong here?
View Replies
View Related
i need to combine 2 vriables that are retrieved from a form. idate and
itime.i want to put these into the t_date field in my sql db. but for it to work
properly, there needs to be a space between the idate and itime.
how do i do this?
i know i should know this, and i have used it before. but it has been so
long, that i can't remember for the life of me.
View Replies
View Related
1. dopage.asp?<% =SessionID=value_here%> is different tha
2. dopage.asp?<%=SessionID=value_here%> ??
Please note that there is a space between the asp tags and the = sign in the first item. I thought ASP will treat #1 and #2 as the same. However it seems that is not the case.
View Replies
View Related
can anyone fix the space problem in my sql statement? I am getting this error message:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
This is my sql statement:
sql = "SELECT * FROM " & tblname & " WHERE " &Col& " = N'" &Var& "' AND [Show]=1 ORDER BY [Code] ASC"
And I am passing the parameters to the url something like this:
Product.asp?Visit=Yes&Var=Hong%20-%20Kong&Col=Place
Problem is that most of my data contain a space (eg. Hong Kong).
I don't have this error when my data is single word (eg. Sydney)
View Replies
View Related
I want to check the disk drive space on a small intranet. Like 30 computers. All have been partitioned and have a D: drive that is shared and is the drive I'm trying to check. This is basically what I have tried:
Code:
Dim fs, pcdrive, cdrive, n
Set fs=Server.CreateObject("Scripting.FileSystemObject")
Set pcdrive = fs.GetDrive("xx.xx.xx.xxshare01-d")
Response.Write("Share01 Free Drive Space is: " & pcdrive & "<br>")
set pcdrive = nothing
set fs = nothing
Is there something wrong with the code or would it possibly have to do with permissions? When this script runs,I get a page cannot be displayed.
View Replies
View Related
when it writes the varFault option to SQL, there is lots of whitespace written too!I have tried the Trim option but to no joy
<%@LANGUAGE="VBSCRIPT" %>
<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, varName, VarExt, VarFault, varDept, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
varName = Request.Form("name")
varDept = Request.Form("departments")
varFault = Request.Form("txtFault")
strSQL = "INSERT INTO new_calls (Name, Department, Fault) VALUES "
strSQL = strSQL & "( '" & varName & "','" & varDept & "','" & varFault & "')"
strSQL1 = "SELECT * FROM new_calls "
strSQl1 = strSQL1 & "WHERE call_id= '"'
set objRS = objConn.Execute(strSQL)
%>
View Replies
View Related
Say I have a 'Mc Paul' in the database, what would i need to do if the user searched for 'McPaul' how could i pull that record out of the DB.
View Replies
View Related
I'd like to know how can I make the first letter of every word on a textbox field, uppercase, automatically. I'd like to use this for the Name and Surname field, but I don't know how?
View Replies
View Related
Now that my website is compleate(ish), I am looking for server space(for free) to host it on. A lot of the ones I have seen, for some reason, do not support classic ASP.
View Replies
View Related
Sometimes I am getting the errormessage "Out of string space ". The error occurs on this code:
sBrf = sBrf & sBodyTmp & "par page par "
When this occurs len(sBrf)<100.000 and len(sBodyTmp)<10.000. Also there is about 1,5gb fysical memory free. I am using Windows 2000 IIS5. I tried isolating the proces in IIS to make sure no other scripts are involved, but it doesn't help.
View Replies
View Related
If I try to retrieve a char field from MySQL with 11111111
in the field I have no problem, however if I put in: 11111 111111
then it doesn't retrieve the part after the spaces it seems to just chop it at the first space. Can anyone help my with the code to make it work.
View Replies
View Related
where i can find a myspace clone?
View Replies
View Related
I trying to find the memory occupied by the object in RAM, For Example:
Set ObjTest = Server.CreateObject("ADODB.RecordSet")
I need the space occupied by the ObjTest in RAM. Is it possible ?
View Replies
View Related
