Recent content by tuam1234

ya mine problem was a deliminater problem and i solved it and i messed it up again be adding another condition to the where in the sql statment: query1 = "SELECT Quant, flightID FROM Holidays WHERE Quant = '" _ & Request ( "Quant") & "'" _ & " AND flightID = '"_ & Request (...

thanks a mil, that did the trick..

i appreciate all replies!!! does anyone know why im getting this error... Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /paycheck3.asp, line 74 the line in relation to this eror is...

could someone please help me.. im tryin to allow someone to login and even if they enter the correct name and password on a previous form, they stll get direected to choose.asp in the "if".... why can anyone tell me??? its prob something simple but i ant seeing it.. <% 'Dimension variables...

if someone could see what im doin wrong id really appreciate it!!! in the code below im trying to reduce the value of the "Quant" field by 1 in the Holidays database.. the prob is the it will display the new reduced value on the screen BUT it wont update it in the database, it remans...

thanks a million to both of ye for replying to me. it actually was a case of the form tag been in the wrong place.. thanks again! :-D

to answer VB Rookie first: ya i tried that and i get "error type: ADODB.Field (0x800A0BCD) Either BOF or EOF if True, or the current record has been deleted. Requested operation requires a current record." tony iv the line of code wrote in at the base of the 1st asp after the final End Sub...

hey guys, i no its st pats day but can someone please help me!!!!!!! i have an asp that populates a dropdown box with destinations. i chose one of the destinations from the dropdown box. this leads to another asp where i want my choice and the database information to be displayed on the 2nd...

thanks for getting back to me. no george, i tried again but im still getting "ur cart is empty"!

yes it works to the extent that no matter what quantity i enter i keep getting "ur cart is empty"!!

ok i no a reckin yer heads at this stage but cud some1 please have a look at this code and c where im goin wrong!!! problem is that i keep getting "ur cart is empty"... il be forever gratefull! page 2 where details of flight are returned and quantity must be entered!!! <% 'Dimension...

thanks for that chopstik :> il check it out!

thanks for that george....but im getting an error: Error Type: ADODB.Connection (0x800A0E78) Operation is not allowed when the object is closed. /newcart.asp, line 56 thats in relation to : if Session("cart").Count>0 then do youve ne idea why im gettin this?

could someone please please help. i got a shopping cart off the net. it is one where the have static information about the items included in the code.. problem is, i want to change this static information to information taken from database. i have recked my head for the last 4 hours trying to...

thanks for replying... il explain what i wan ta bit better. i have a credit card details form and i need code that will show an error mge if the user enters an invalid expiry date, eg 02 2004 (invalid), 04 2004 (valid)!!