Hi there

I'm using ASP and SQL Server.

Can anyone help me with the following quick query:

I've got an insert page with a textfield called 'date'. If I enter in a wrong date e.g. 30/02/2003 and press submit I get the following error on my process page:

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

Obviously my process page comes across this, runs the stored procedure but hits the 'date' problem.

I'd like to put a 'nice looking' error message that writes at the top of my insert page 'you've typed in a wrong date' but am not sure what ASP code I need to put on my process page.

Any ideas?

Thanks in advance.

Lucy

Hi Lucy

Can't you use some asp and javascript?

For instance:

<%
    if varDate = "" then
%>
<script Language="Javascript">
    window.alert("You must enter a valid date.");
    history.go(-1);
</script>
<%
    else

...........the rest of your code

end if


hth

Adam

At the moment i've actually got 3 dropdowns for day, month, year. On my process page these get 'joined' together so that the stored procedure reads it as: day & "/" & month & "/" & year.

This then makes it a little more complicated doing your suggestion on the insert page, rather than the process page.

Any ideas?

Lucy

Right, so am I right in thinking that the sp will insert the date no matter whether it's valid or not at the moment?

No, it obviously gets to the 'insert date' bit of the stored procedure, knows it's wrong and puts the error:

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/formhandlers/process_add.asp, line 184

which relates to the line:
Command1.Parameters.Append Command1.CreateParameter("@BDate", 135, 1,8,Command1__BDate)

I think, if I can't do what I want, i'm gonna have to change from 3 dropdown boxes to one textfield and then have the validation on the insert page.

Lucy

Why don't you validate the date on the insert page and only transfer to the processing page if the date is valid? If the date is invalid, stay on the insert page and write out some error message.