I have a web form (fine so far) which POSTs to a PHP routine which mails the information. Very standard. Now I would like to update a database as well as emailing the form contents.
The problem is that the database has to br MS SQL and I can't install the bits to make it work with PHP - so the database part HAS to be ASP. The mail bit HAS to be PHP as that's the only mail routine I can use. Code:
I'm trying o get my head around XML and using ASP to parse documents.
I've managed to kncok together the code below to send a request to an
external server and then pop the response into a variable and format it
a bit.
What I'm trying to do is insert the data into a nice HTML table, maybe
using the node names as column headings. Has anyone got any suggestions
on how I can do this? and also, is this the best methid of performing
this task? I need it to be xbrowser compatible so I figured server side
would be the best option. Code:
I've written several scenarios where the end user needs to enter data into a textarea (descriptions, messges etc) which becomes part of a form. End users often put apostrophe's and carrige returns in the textarea... however, when the code i write is submitted to the database, it generates an sql command from the page that sent the action.
Client Side:
<form action="somepage.asp" method="post">
<input type="text" name="emailaddress">
<textarea cols="20" rows="5" name="comments"></textarea>
</form>
On code submission...
sql="insert into tableName (email,comments) values ('" & request.form("emailaddress") & "','" & request.form("comments") & "');"
db.execute(sql)
Now, when strange people put carrige returns, it stuffs up the string and therefore produces an error, and to make matters worse if it did recognise a carrige return, it wouldn't be displayed on HTML output. Apostrophes are even worse - they signify the end of a variable in the SQL sentance Can anyone help me and figure out a new way of writing to the DB?
I'm gonna be writing a new ASP based system for work for staff to book in deliverys with our warehouse - I'm starting to think about the database design and i'm trying to think how best to work it - Each day will be a record - with a date field - but I have no idea how to automatically create a date field with concurrent dates - and also we can book deliverys upto 6 months in advance, so there needs to be a lot of records created.
View Replies View Related<%
dyear = year(RS("dates"))
dmonth = Month(RS("dates"))
dDay = day(RS("dates"))
response.write dyear
response.write dmonth
response.write dDay
%>
i get 2003 12 9
how do i dispaly 2003 December Tuesday
is it possible to do a insert, add, and a redirect all on the same page?
for example... signup.asp. there's a text box labeled Acctid. If you don't have an acctid please enter "0000" otherwise enter one. This box is used to see if they have an existing account in the database by using an UPDATE query and if they don't it does an INSERT query with acctid = 0000 for all non customers. What I want the if.then.else statement to do is to
If acctid = "0000" then
conn.execute acct_add
(and if sucessful to response.redirect "/yay.asp"
Else if NOT acctid = "0000" then
conn.execute acct_update
(but I want it to return an error if the update wasn't sucessful either because the acount doesn't exist or watever and if the update was sucessful to response.redirect "/yay.asp") END IF
Do ya get it?
I am about to get rid of TZO on my computer, and I've been using it's photo software to view photo's on my web site. I could write something in ASP (or asp.net), but I figure why spend time re-inventing the wheel if there's something already out there.
Does anyone have any recommendations on ASP apps that I can use for viewing photo's on my web site? I would rather it be free if possible, and it needs to just look at a folder, or series of folders, and build a thumbnail type of view from what's there. In other words, I don't want to have to populate a database with all of my pictures.
I have a combobox that on page load is disabled. I've noticed that the information will not load into the combo box if this is the case. Is there a way to load the information and then disable it so the user has no idea what has happened? I load another combobox before this one, that is NOT disabled and so loads properly.
Code:
="1" name="County" disabled="true">
<%
While not objrs.eof
%>
<option value ="<%=objrs("County")%>">
<%=objrs.fields("County")%>
<%
objrs.movenext
wend
objrs.close
%>
I was wondering if anybody could help me translate this from my native Cold Fusion tongue to ASP? :
#DateFormat(Visitors_DateTime, 'dd mmmm yyyy')#
#TimeFormat(Visitors_DateTime, 'h:mm tt')#
The data is held with SQL2000 in a smalldatetime datatype column.
Would just like to display the full date and time really.
I am trying to write a simple script that will allow me to have someone complete a form and depending on which location they choose an email will be sent to a specific person.
I have a page that validates and sends and email to me correctly, now I am trying to simply add a case statement that will allow me to change the recipient to the individual it needs to go to. What am I doing wrong? Is there another way of doing this?
Basicly I would like to know how to transfer data entered on a form one one page, to another - for example a signup:
Page one - Contains initial form
Page two - other details form ] both pages emailed through the same form.
I am trying to take that is submitted in a form and put it into a querystring. I have a text field with the name "company_name" and has the value of <%= cCompany%> when submitted I want to take the value of the text field and send it to another page called submit.asp. then from the submit page I will append it into a table. I can append to the table fine but when I pass the value its blank. I have tried Request.Form(company_name) and Response.Write(cCompany). None of these seem to work the variable is always blank when I submit it. I can use javascript to get the value, which works correctly but cant dont think I can pass a javascript variable into a querystring.
View Replies View Relatedhow come the second one has the forms lined under eachother
when the first one looks like it does?
How do i make the "boxes" in a straight line under eachother?
I’m working on an Invoice page. The user may edit some of the vars on the page. Then The user will want to re calculate the totals. Then after seeing the re calculated totals then I will want to submit this info to the next page where the data will be put into a DB.
The question is how do I do this without using 2 forms, It looks like you can not put a form with in a form. Yet it looks like that’s the only way to be able to pass the vars iEither to the page where were calculate the vars, or the other page where we submit the data to the DB.
i have
printerdropdown = printerdropdown & "<option value=" & rsPrinter("id") & ">" & rsPrinter("id") & " " & rsPrinter("name") & " ( " & rsPrinter("location") & " )</option>"
and want to pass two variables across my forum by selecting just the one.
i.e. rather then just passing rsPrinter("id") id also liek to pass rsPrinter("ccid")
But dont know how to without making it joined when i cann it on the next page via request.form("printerid")
Is it possible to call ASP functions from event handlers? I am trying to find a way to have a form call an ASP function, if there is a better way let me know.
View Replies View RelatedIs it possible to create a form that will authenicate against a 2003 domain?
View Replies View RelatedA client of mine has a couple of simple contact forms on their web site and they have asked if I (their web guy) could put together an ASP Form for them as their current form is out-dated and the radio buttons don't work right.
Not only that but, they do not even have a re-direct page setup so when a prospective customer completes the form and hits "submit" the form they just submitted stays in their browser window.
I have put together html forms but, I was wondering if I could get some help with creating an ASP Form for my client with disrupting the format & layout of their current Forms?
I have checked out some ASP tutorial sites but, they really do not give you the full picture in creating a "working" ASP Form.
how do you get the infromation from a form and put it into a database using sql .
View Replies View RelatedI am trying to create a page with a drop-down select upon it. When the user clicks on a selection I want a new frame to appear with a new URL (associated with the selection) appearing in it.
previously when I have used select I have passed the value to the new page, but this time I want to go to a different page depending on the selection.
I have a very large form that clients will enter data into. When they submit the form I would like a page to come up where they can opt to confirm the form or go back and edit the form. I know this is possible is there a way to automate this so I dont have to retype the whole form again putting all the data in manual.
View Replies View RelatedI need the form to be emailed to me once the form is complete. the problem I'm having is when the SUBMIT button is selected I receive a HTTP error 403.1. My web server admin isn't sure what is causing the problem. Is ASP the best way to go?
View Replies View RelatedI need to collect course registrations, with cc info, via an ASP registration form that would operate under SSL. The order info would be stored in a database that resides outside of the public web directory.
If I write a password protected utility that runs under SSL that allows the person processing orders to view/print records in this database under SSL so they can be manually processed, and after printing delete the cc number in the db, realistically, how secure is this? Host won't let me use PGP.
They don't want to use Paypal, and can't get an online merchant account because they're considered a high risk business (travel). What other options do I have?
im creating an application form for an existing site. The pages are all .asp but my form is .php. I have never explored asp before and know very very little about it. Not sure of the easiest way to create this form within these pages.
View Replies View RelatedI have a form with 6 multiline text boxes each accepting data to be stored in a memo field. the form accept as much date as can be typed, but refuses to send data after
a certain limit (havent actually counted the # characters).
Is there a limit to the number of characters a form can send, or is it some other design problem.
Basically I have a form, where I have 6 option boxes, say Option box 1 has 3 options in it, being A,B,C. Is the a script around than when a user selects an option them form gets reloaded with the same option boxes, but between the first two option boxes a Text box appears with a certain label, this labels is altered depenging on the users selection. Code:
View Replies View RelatedI have built some ASP forms using Dreamweaver MX. I do not know much about ASP, so here is where I need help. The forms are writing to the databse with no problem.
how to get an email sent to the user confirming submission and to the admin, letting them know that the form has been filled out. Im sure it is not to complex to achieve this, but I am just not sure where to begin.
I have a form that is using the godaddy gdform.asp file for it's action. The form is simply to collect a user's information and then take them to a brochure download.
When they click on any of about 100 brochure links in the site, I would like them to go to the form, then after they fill in their information, have the submit redirect them to the correct brochure based on the link which brought them to the form.
I need to create a form that has 2 fields, the first the user can enter information in set from a list of 12 things and then the 2nd returns the results from what ever they enter.
Any Ideas?
Tomorrow at work I'm away to make online form for a website that sells insurance. The user is going to have to fill out all his/her details online and they then get emailed to someone in the office who then prints out the email, and from the details the online user had submitted, calculate a quote and call them back. Code:
View Replies View Relatedi've got to build a form in a page that lives on a WIN2K machine. No cgi-scripts are installed (i usually use formmail) and i figured this server will allow me to use ASP.
The problem is, i don't know ASP. Error!
Does anyone know how easy this is or where i can download an example from? I'm guessing there is a file that has a load of ASP code in it and the form is submitted to this file which then does its magic and forwards it to the recipients email. would that be true?
When getting form values i usuall do
Code:
varName=request.form("fieldName")
but this has gotten long and tiring with large forms. so i tried
Code:
for each item in request.Form
item=request.form(item)
next
but it didnt work.
I am looking for a way to do a validation in the form that who ever is filling the form is a true person & not a automatic system. there is a way to do it with letters in an image & the user must enter the same letters in a text field.
View Replies View Related