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 RepliesAll 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.
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:
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.
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:
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.
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 RelatedIf the physical path of a page is :
" e:facecgi_bindetails\_Nviews.asp "
and i want to remove "\_Nviews.asp" portion from this path.means whenever the page refreshes,no matter what the name of the page is.the last portion of the name of the page with slash must skip out from this path string .....how can i do this while using VBscript Functions.....like using Split(),RIGHT(),LEN(),LEFT()...etc..
How do you make the following skip the first field?
Code:
<%for each x in rs.Fields%>
I want to skip an item in a loop, and go to the next item, e.g
[vbs]
For Each bla In ble
If bla = "skip" Then
'Skip to next item
End If
Next
[/vbs]
Is this possible, and if so, could you show me how?
How do you make the following skip the first field? Code:
<%for each x in rs.Fields%>
i have a recordset in a results page
this retrieves all records but i only show the first 6 with all details (using a repeat region)
then i want to follow this with just thumbnails of the additional results
- this repeat region uses the horozontal looper
Either i need this second repeat region to start at number 7
or i need another recordset but with sql to ignore the first 6
(database is access)
can anyone offer any guidance on either solution?
I searched an issue on the net and in our forum but could not find any solution. My question is :
How to skip some block of code while programming in asp page so that I get the necessary part of page only???
whenever i fetch any numeric value, having a zero at the end, e.g. 32080, from a database with a recordset object, i find that the value becomes stripped of the last zero, i.e. it becomes 3208.
View Replies View RelatedIf the physical path of a page is : " e:facecgi_bindetails\_Nviews.asp "
and i want to remove "\_Nviews.asp" portion from this path ...means whenever the page refreshes,no matter what the name of the page is ....the last portion of the name of the page with slash must skip out from this path string .....how can i do this while using VBscript Functions.....like using Split(),RIGHT(),LEN(),LEFT()...etc..
What I need to know is how to click on a button that is labeled NEW, as in new record, and have the current form open to data input. That is a blank record. After the user then inputs the data to all the fields on the screen and hits the SAVE button the record will then be placed into the database table.
View Replies View RelatedI am trying to use AUTH_USER from request.servervariables but the field is
blank. I am using Windoze server 2003 with IIS5. I know there is a fix
because I did it a long time ago with our old NT server running IIS4 but I
cant remember how I got it to work. We are all authenticated users on our
Domain so this is available, I am able to get IP info and such. I seem to
remember some kind of ASP code that did the fix by altering the way the web
server displays info.
The host Im useing is useing plesk as its control panel if anyone has ever heard of that...I hadnt until this site.
when I try to load a asp page on my site it just loads a blank page.
The page is a data base editor page that I had built useing fp 2002
all my other asp pages load fine.
But this one just loads a blank white page
No errors no nothing. Code:
I had a problem for a while where data was added on its own, and BLANK data. I found out it was because i was opening the processPage.asp to see if it was working, so that was inputting data out of the form that wasnt there. So i get blank data. Is there anyway i can make the process work ONLY if there is data in the form?? Code:
View Replies View RelatedI am creating a directory of suppliers.I have a form that collects data - business name, address1, address2, town, city, county, country, postcode.
The data is stored in separate fields in an Access database. Another page is used to display the data, one field per line. However, if some of the fields are blank, I want to suppress the blank liens as at the moment I am getting:
My Business Name
1 High Street
Any Town
Any County
Postcode
United Kingdom
I have a drop down list, values coming from a db, when I come into the form I want it to have no value - how do I do this? Also, if I want to capture the value that a person selects from the drop down list do I need to use a session variable if I want to print it to the screen after they select it?
View Replies View RelatedI want to clear the date in a field in an access table by entering a blank. Does anyone know the syntax for that in the select statement? This is via an asp page
The select statement I am trying to use
<code>
strQ ="Update Inquiries set ShutOffDate= 00/00/0000 WHERE CustomerID = "&CustomerID&""
</code>
I'm getting some errors in my .asp code somewhere but I can't seem to figure them out because all I get is a blank 500 error screen. I don't get any description of the error, just a blank screen so I don't know what the problem is.
Just wondering if there's a way to get the results easily because I do not have admin rights to the server so I can't make a custom 500 error page or i would.
We use Vignette V5.6 to display our site. In our CMA site, we have a page which has FRAMESET and in one of the frames we call a ASP page. There seems to be some problem that the frame shows the ASP page is blank. When we restart the IIS it works fine. But after some time it again shows the blank.
If we get one blank page, all the asp pages under the same virtual directory, called in the Frame shows blank. FYI. The Vignette template which contains the frame is marked for NO caching & For itnernal use only.
I want to know how I can check if a querystring exists, whether it has a value or not.
Basically I would like to use test.asp?login without having to use ?Login=blah.
I have an online application made up of ASP pages (IIS 5.0 on Windows 2000 Server) drawing data from a SQL Server database. Most of the time, everything works exactly as it should. Connections are opened to the database, queries are run and data is returned and writen out, connections are closed, etc.
However, every so often a page simply won't load. It isn't trying to load and then timing out or anything, it's like it's ignoring the page entirely. It shows the correct URL in the address bar of IE, but there's nothing but a blank white page displayed. Viewing the source of the blank page reveals that instead of the correct code for the page, we get this: Code:
The code referer = request.servervariables("HTTP_REFERER") used to return a
requesting URL. It now returns blank. Anyone any idea what is happening?
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".
Ok, I have two pages. One that displays the table (page a), and one that exports the table to Excel (page b). When you click the "Export to Excel" link on page a, page b automatically opens up the save/open dialogue box for the Excel document.
Everything works fine on my computer (whether you choose to open or save), however on MOST computers it seems, the Excel document is blank with the exception of the column headers. Here is the code for page b which does all the exporting. Code:
i am creating a dynamic protofolio page in asp. in that page admin will fill up all the fields . i am giving u the html code here Code:
what i am trying to do is when the database field is empty to not display the box (table) that is in my css file, whereas when there's something in the field i would like the box to display!!! So i'm basically trying to get a 'when field empy, do nothing!!! my code at present generates the box no matter whether the field is full or not!!! Code:
View Replies View RelatedI am trying to do something that prevent user submit blank data to my database.
Here is my code: ....
How do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then
Response.write(bla bla)
else if tf.value = null then
Response.write(bla bla)
else
Response.write(bla bla)
end if
*Note, where the word null is, I have also used the string "" and it still does not work.