2. ASPRunnerPro General questions
  3. First time user: MS-SQL Date update problems
This topic is locked

First time user: MS-SQL Date update problems

 		5/14/2004 11:16:30 PM
ASPRunnerPro General questions
P
 PerOfoslo author

Hi, I'm testing this program (PRO 3.0) now:
I like the interface (although it sometimes seems to get confused about where it is - reloading a not working project mostly brings up the SQL connection dialogue;)

No problem - kill the program (<span style='font-size:8pt;line-height:100%'>but a bug...?)</span> Even if not saving to project the interface may not work properly after this error until a restart of the PC (2ksrv)?
MS-SQL - There seems to be a serious problem with datetime variables? Including any table with non US datetime fields kills the application? I suppose it works with an US MS-SQL installation, but I have none around to test with as I need extended characters (Tables in old format - Norwegian). Removing datetime fields from "List/Edit" brings the "application" up again with no problems. (Serious BUG!)
On the funny side; The login function on protected "applications" seems to be somewhat erratic as the selected table-fields may not always be used, but default (?) field names that happen to be in the table are selected instead = no login possible and error message (wrong...) disappears.
Viewing the generated code I must say it seems rater saturated due to some degree of missing general variables and functions to take care of things?

  • But I guess you are the expert on ASP - what works is fine and fast enough!
    But for my date problems that makes this program useless, I suppose it works great! - I think I will try the .NET version and see if MS-SQL works for me there!
    Thank you for a very well thought-out program-generator, it is certainly very useful, but please don't forget to keep it simple <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=595&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
    PerOfOslo
Sergey Kornilov admin 5/14/2004

Hi,
could you send me ASP files, project file and SQL scripts to create required tables in SQL Server that illustrates datetime fields problem. Zip and send it to support AT xlinesoft.com.
ASPRunnerPro proved to work with many non-US SQL Server installation. How exactly this kills the application?
P
 		PerOfoslo author 5/15/2004

<span style='font-size:14pt;line-height:100%'>oops...</span>
-forgot to tell the error!

On Update in SQL the date is a char variable - should be date...
Per
P
 		PerOfoslo author 5/15/2004

I did send you a file with the x.sql and the update/add.asp file, but I am sure you know that ASP code by heart (as I do now) and know everything about SQL databases (I don't). My problem is that dates do not work! Plain SQL is not hard even for dates (a date is a date), but with VB/ASP and your special code it is not always easy to see how what is going wrong!
My (your) problem is conversion from character dates in the browser to real dates for MS-SQL. - This is very easy if I control the SQL information, but if not: The date evaluation that is made in the aspfunctions.asp file may be fine for Access files, but may not work correctly for MS-SQL? MS-SQL may treat dates and some other variables different from Access? So there may be a problem with converting from char to date for MS-SQL in the aspfunctions.asp file?

I believe I see the solution, but rewriting the code after every build is not practical.
Is this version of the program supposed to work with MS-SQL but for the connection?
Yours sincerely,

Per
Sergey Kornilov admin 5/17/2004

Per,
I haven't received your files. Where did you send it?
Also I need to see exact error message and exact SQL query that caused this error.