Re: The third time to ask in here ... Mobile Web form
From: Doug Forster (doug)
Date: 07/06/04
- Next message: Ben Terry: "Re: byte[] to struct"
- Previous message: Whidbey: "Re: help with example "paint on form by mouse""
- In reply to: Amal Ismail: "The third time to ask in here ... Mobile Web form"
- Next in thread: Shakir Hussain: "Re: The third time to ask in here ... Mobile Web form"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Jul 2004 11:58:32 +1200
Hi Amal,
You would be better directing sql server questions to the
sqlserver.programming group. Having said that I think your problem may be
due to not concatenating single quotes around the user entered MyDate value.
If your user can directly enter this value then you should also read about
sql injection attacks.
Cheers
Doug Forster
"Amal Ismail" <free_rhythm@alex4all.com> wrote in message
news:279c201c4639c$fc558e90$a401280a@phx.gbl...
> hello
>
> this is the third time i inquire aboutthe same
> thing and none answer me !! .. hope to find help here
> i'm using ASP.NET Mobile web application using c#
> And i'm facing a problem , i use SQL server Database
> I've table inside it a column of type smalldatetime &
> i can't change its format , and in the mobile webform
> i've a textbox the user enter a string on the format
> mm/yyyy ... i need to compare it to the date in the
>
> database And show a certain value to the user depending
> on the entered date so i either need to change the date
> format in the DB to string or the string that the user
> enter to date format
> i've tried to use this phrase in the select statement
> ex :
> string Value_select_text="select value from
> MONTHLY_Indicators_Value where convert(varchar(30),month
> (indicator_date))+'/'+convert(varchar(30),year
> (indicator_date))="+MyDate;
>
> where MyDate is the string that the user entered but it
> gave me a strange error
> Syntax error converting the varchar value '1/2002' to a
> column of data type int.
> supposing that the user entered 01/2002 as a date
>
> Best Regards
> Amal
>
- Next message: Ben Terry: "Re: byte[] to struct"
- Previous message: Whidbey: "Re: help with example "paint on form by mouse""
- In reply to: Amal Ismail: "The third time to ask in here ... Mobile Web form"
- Next in thread: Shakir Hussain: "Re: The third time to ask in here ... Mobile Web form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
