Application run lacally fine but when uploaded then unable to get data

Question

0.00/5 (No votes)

See more:

Hey...!!!

i am facing a unique issue i.e. when i run my application locally then every thing goes okay. but when i upload my app on server and access from url to do a booking then front end works fine and data stored in database but when i go to view my all booking then store procedure failed to get latest record...

Sp has a where clause on Date. when i remove it then exe okay with new record but with where clause its not working... :(

where as same app is uploaded on another server then it work awesome with same SP with date filter...

cant understand where is the problem...

Posted 9-May-12 21:24pm

bilal _hassan

Add a Solution

Comments

Bernhard Hiller 10-May-12 3:31am

Is that "Date" stored as a date value or as a varchar?

Dhanamanikandan 10-May-12 3:45am

Please share ur SP with Data type..

thotanagu 10-May-12 4:20am

If your code and db are in the same server then it is ok.
else you need to send the db server date to sp from your code.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rob Philpott · Answer 1 · 2012-05-09T23:00:00

Sounds like a region issue. How are you supplying the date? If it's parameterised you shoud be ok, but date formats vary around the world and will be interpreted on the computer according to the Regional settings specified.

If at any point you are passing it as a string, format it such 'yyyy-mm-dd hh:mm:ss'

Tejas Vaishnav · Answer 2 · 2012-05-09T23:27:00

I think you need to format your date to a unique format so if any server has set to different region or its date format is some different then you use then it will cause issue same like you face one.

so you can do like this...

if you use a system date to compare with your SP where cause then use like this..

first of all convert your where cause date to particulate format like "dd-mm-yyyy" OR "dd/mm/yyyy" or any thing else

and other side where you use comparison date (System date) you need also to convert it to the same format you use to convert your where cause date.

Application run lacally fine but when uploaded then unable to get data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0