Search results for query: *

hello all, I have dates in a varchar column in my database which are US and UK (MM/DD/YYYY and DD/MM/YYYY) Bad news i know, , but we want them all to be UK, however they are all mixed up! Is it possible for ASP to determine wheather they are US or UK? help! Thanks...

Hello all, I have 3200 entries of user Date of birth (DOB) entries in MM/DD/YYYY as a varcvhar. i need to change these strings into DD/MM/YYYY, basically swap the numbers in the string around. Is this possible? _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - Doh...

Hello all, i get the following error The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. When i execute Update tbl_users Set user_dob = convert(smalldatetime, user_dob, 103) Where user_dob is not null I am trying to convert...

Hello all, I have a large database of user which used to use an amercian based server which stored all birth days as 03/21/1998(MM/DD/YYYY) in a VarChar column... ...Later we switched our server and the dates where then been stored as 26/12/1998 (DD/MM/YYYY)... As you can guess this is a bit...

Hello all, I have a silly mistake in thos validation script for a dropdown box. "object expected" function valformstart(start) { strError = "" if(start.customer.value == "") { strError += "Please select your title\n" } } <img src="images/continue.gif" name="submitbut"...

hello all, i have a coloumn in my database which is: user_dob varchar 100 and i have created a stored produre to select email address where users are between certain dates. However it is now working can you help? CREATE PROCEDURE GetByAgeEmail AS SELECT user_email FROM tbl_Users...

Hello all, Surprised i couldnt f8ind the answer on google but i need to limit the length of a string retrieved from database. can you help? "something like this......" Thanks you _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - Doh http://www.my-portfolio.me.uk

Hello all, I have the following script which works great for check boxes and and links however radio buttons are a bit annoying. Clicking a radio button will DISPLAY a tablr row containing infomation. Clicking another button (which hase the same name) displays that options info ande should...

I have a Javascript function that returns a value and places it in a read only textbox. This isnt working on safari, the text box remains empty, The functions works perfectly in Firefox and IE! Here is some of the code. the following returns the result. var total var discount total =...

Hello all, does anyone have a credit card validation script that acutally works, i have used a few i found online but there seems to be endless debugging. The foillowing cards will be used MasterCard UK Maestro/Solo Visa / Visa Electron Switch Laser (ROI) also if you have any scripts...

hello all, I have recently created the following JS wich works perfectly except it is not showing the 0 (zeros) values in the targeted text box. For example a 0.00 value does not show nothing and 13.50 shows as 13.5 can you help? here is a sample of my code if (prempack == 4) {...

Hello all, I need some pointers on how to approach this task, had a look on google but not finding what i need. I need the summary section of my page to update everytime a user clicks a checkbox of a package they want to buy (let say they are £10 each) The output value should also go into...

hello all, i have used this radio button validation before and it has workied, but isnt working on my new form. can you help? Here is my form head <form name="form" method="post" onsubmit="return valformPage2(form);" action="default2.asp?id=<%=id%>&ref=<%=ref%>"> And the javaScript...

hello all, I would like to close the popup window when the close button is clicked, and then refresh the parent so all the updated detals show. <script language="JavaScript">window.close();</script> <script language="JavaScript">window.opener.location.reload();</script> problem I am...

hello all, i have the following form header which keeps bringing up this error? Microsoft VBScript runtime error '800a01f4' Variable is undefined: 'contactEmail' the form head is .Write "<form name=""rejct"" method=""post"" action=""subReject.asp?rjtsub="& iSubmissionID &"&emailadd=" &...

Hello all, I am getting the following error: ADODB.Command error '800a0d5d' Application uses a value of the wrong type for the current operation. D:\WEBSITES\PROD03\COMMISSIONER\../_inc/_submission.asp, line 93 it is pointing to: .parameters("@FromAssistantID") = iAssistantID Here is...

hello all, i have the following button which is executein inside a asp response.write function but the queurystring ios not passing. .Write "<td align=""right""><input type=""button"" name=""btnEmail"" value="" Send Email "" style=""width:100px;""...

Hello everyone, I have a simple form which is failing to post. I have looked high and low. Can you help? I have taken out some HTML to clear it up. Here id the form which displays resultd from a request.querystring and puts them into hidden fields (this page works fine, QS display fully...

hello all, i have the following stored procedure set up which inserts a form objects into a table CREATE PROCEDURE SP_EmailSend @submissionID int, @message varchar(5000)=null, @sender varchar(50)=null AS BEGIN INSERT INTO tbl_sendmessage (submissionID, message, sender)values(@submissionID...