Receipt Based On Database Input
i'm trying to show a message where a user can print after checkout. i have 2 pages, the checkout page and the validate order page, where the checkout page displays a form and the user will fill this page and submit the order, then the order will be stored in the database in a table called Orders where the Order ID is generated automatically, and the date is also stored using the date function.
now what i need is after the order is being stored in the database the validate order will be called to display the message that the order has being received, well i need to add the two fields (Order ID, date) from the Orders table based on this specific order.
How can i do that ?
View Replies
ADVERTISEMENT
I need dinamically calculate input text field based on parent static TD
before showing content of input.
View Replies
View Related
i need web based mssql database manager.
features
create table
edit table
del table
add-del-edit records
and free
View Replies
View Related
So far I've been using Sets to read information from the database (Set RS = Server.CreateObject("ADODB.RecordSet") and RS.Open queryString, Conn)
I've got a situation now where I have a function which returns just a single value. I call this function using "SELECT myFunction(parameters)". I can't use a result set to retrieve the function return value, can I? How should I do it?
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
how do i allow the user to add in a value that has a ' in it (e.g int'l) in the form. apperantly if i do that there will be an error... how do i go about this?
View Replies
View Related
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies
View Related
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
View Replies
View Related
I'm using Access Database with ASP. There is one particular thing that I
have issue with.
My purpose is for user to update their own profile. Their existing profile
information will be display in Edit Form format. The problem is if the field
has space, the second word will not display, when I display in input text
format.
E.g if My first name "User_FirstName" in my table has entry, let say "David
Johnson" as FirstName, when I execute following code and do a input text, it
will display "David" only. Code:
View Replies
View Related
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other
contact table
id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
View Replies
View Related
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other:
contact table id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
View Replies
View Related
Does anyone have some example code on how to receive an xml document sent to the server ?
I`m using 'Msxml2.ServerXMLHTTP.3.0', but can`t seem to get it working.I just want to receive the xml document and insert it into a database
View Replies
View Related
Anyone know if it's possible to add a read receipt to emails sent via CDONTS or CDOSYS
View Replies
View Related
I am using myMail.DSNOptions = 14 n a script that uses CDO.Message to
send an internal mail. Is there a way to access the delivery status in
the same script and report a bad route...below is an example I would
like to achieve.
Example:
Sub sendMail(msg)
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Queues|Critical"
myMail.From="ExMgmt@us.panasonic.com"
myMail.To="santhoshs@in.ibm.com"
myMail.TextBody=msg
myMail.DSNOptions = 14
myMail.Send
set myMail=nothing
<----------------------------If message not delivered Wscript.echo
"mesage not delivered" else "great job" end if ------------->
End Sub
View Replies
View Related
Is there a way to request a read receipt when sending out an email?
View Replies
View Related
I'm trying to setup a receipt page to finalize my whole shopping cart deal.
PayPal is used to pay and it uses IPN to return the data back to my script which inserts everything into the database and then forwards to my receipt page.
The IPN script page stores the orderID under a session variable called orderNumber. With that, I've created recordsets on my receipt page to hold the orders and orderDetails information just fine.
My problem is that neither of these tables hold the product's name so that I can display line items. The orderDetails recordset does have Product ID and is related to the Products table in my database by the productID field.
How can I make the receipt page list the actual names instead of just the IDs?
View Replies
View Related
I have an electronic cash drawer as part of a point-of-sale installation. You're supposed to be able to automatically open the cash drawer with some printer commands (drawer is connected to the receipt printer) but I can't get it to open automatically. I want it to open when the customers receipt is printed.
How do you send printer escape sequences to a windows printer via ASP ? The cash drawer model is ... Posiflex CR-4100 Cash Drawer.
View Replies
View Related
I am learning more and more about asp but can't find and figure out where and what varialbles to add to this form. I want to be able to have this form email to me and to the person that filled it out as there receipt as well.
I don't have it set up to show the results after they fill it out that would be nice but not sure how to do that either. My main focus is getting the receipt sent to the person that filled it out. Code:
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 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
it appears that my ISP is blocking port 1433 which means i can no longer connect to my sql db on the web. had been using an access project or another program called WinSQL. so i'm forced to go with a web-based solution and i don't really have time to build one from scratch. the host this site is on still hasn't installed the .net framework so i have to go with a classic asp solution.
View Replies
View Related
I want to do on my site and if anyone can tell me it can/can't be done that would be great. If it can be done, is it difficult or is there already code available and I can just *plugin* the info that pertains to my site? Code:
View Replies
View Related
I need to open recordset and select one record based on some value?
I need some script which will select random record based on the some percent or some number from 1-10, for example.
Its banner rotation system i have made, and it select randomly record, but I need some percent or some number(1-10) for selecting recordset based on that number.
banner1 10
banner2 70
banner3 40
...so every will be selected based on value from DB.
View Replies
View Related
i found a flash based mp3 player for my myspace that pulls the playlist from an xml file. my question is this... i want to be able to change the playlist (add, delete songs, change play order, etc...) without having to change the xml. here's my idea and i'm not sure how exactly to do all of it, but let me know if there is an easier way.if i create a db that stores the information i need (filename, song title, and track number) i can create an html form that will allow me to change the track number (i know how to delete and add songs). my question is how to i update the xml file at the same time it updates the db. in other words, how to i send the data in the db to an xml file.
View Replies
View Related
How ca I write a asp page that will handle web based Install? Is it possible
or I need to go for some 3rd party Software for this, If Yes what is the
Best to use with ASP?
My requirement is: I have one Software that I wanted to install in Customer
PC directly from Webpage instead of allowing the user to download the
Software and Install.
View Replies
View Related
I have dynamic weather on my site based on the users' zipcodes, but the feed takes much too long to load; therefore I would like to see if it is possible to query a site for a temperature only based on zip, and then use an "if...then" to display 5-6 different gif weather images. I know it can be done... www.dogears.net does it. Or if anyone out there has a good source for dynamic weather and or movies that can be used
View Replies
View Related
i want to develop a small application which will generate a list of
product from a database based on a user web page contents. something
like google adsense but not that extensive. any help or resource
available?
any guidelines. i want to use ASP , access or SQL server .
in short a script page, when called, read the contents and search a DB
for products and diplay it .
View Replies
View Related
I have been mostly frequenting the PHP forums but now my job makes it necessary to get my hands dirty with ASP.
I am trying to find a Forum Software (Open Source or Commercial, doesn't matter) that has all the bells and the whistles. The following are some of the major requirements:Integration with existing Site and DB (including migration of data from current forum)
Ability to apply the look and feel of the site (if various parts of the Forum can be broken down to components/panes/boxes/windows that can be included in other site pages as well as customisable through CSS)
If anyone knows of any software that meets these requirements, please do let me know. Additionally, if you have experience in using that software, your opinions on it will be much appreciated. Currently I am going through some forum's that I managed to find through searching in SitePoint (ASPPlayground, Snitz, Web Wiz Guide, IdealBB). If are experienced with these
View Replies
View Related
I am working on a script for a client that will switch a web element every Monday at 0:00:00 time. I have the entire website finished, however I now need to add a VBScript that will rotate between elements ONCE on every Monday.
If I am being too vague, here is an example:
<img src="puzzle1.jpg" />
I now want to rotate through puzzle1.jpg, puzzle2.jpg, puzzle3.jpg up to 12, then start again (a loop), but only make this change once each week on Monday mornings. So, this week it would be puzzle1, then starting Monday, it would be puzzle 2, etc.
I hope I am being clear enough, if I could provide further code, I would, but I am unsure as to how to start.
View Replies
View Related
I currently have a web-based email for my site for users. Is there any way that I can make this so that it can be accesable from Outlook Express? It would have to call the database for the emails.I would need it written in ASP.It also needs to be free!
View Replies
View Related
iis runs on win2k3.i need to have a web-based app that among others does something like this:
1. login - validate against the local user database.
2. user must belong to a certain group (say backup operators group).
3. create a web-based front end to the task scheduler. create, modify, delete schedules.
i dont have a starting point with regards to the three requirements
View Replies
View Related
I'm looking for asp functions that can do the following:Based on the Month (& year) given I'd like to find out:
1.) The # of days in that Month
2.) The day of the Week the 1st falls on.
View Replies
View Related
preferably in ASP, but perl would be better than nothing. I have seen one vers which connects through telnet - this isn't what I'm looking for. I'd like it to send html to the client, and hopefully support for logging in and updating high scores etc.
View Replies
View Related