MX Kollection Forum :: Migrating from MS Access to MS SQL
This thread was displayed: 0 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
MFP
05-21-2008 18:50:03 GMT +2
|
I am migrating an application I create wuth MK Kollecrtio from MS Access to MS-SQL 2000, I have been ablke to fix most od f the problems except data fields, my application was built using ASP/VBScript, I have a time stam field <%=now() %> that in the MS access data nase saved the date as MM/DD/YYYY HH:MM:SS A/P
In the MS Access table the field was defined a s Date/Time in the MS-SQL table the field is defined as datetime When I try to insert a new date value I get:
"Syntax error converting datetime from character string"
know I have to convert the data captured in the form to a format tha MS-SQL may handle, however I am not sure how togo about this
Any suggestions
|
|
|
Fred at ExelWebs.com
06-13-2008 02:01:08 GMT +2
|
A number of different methods to do this.
If you use the normal Interakt markup you would just define {NOW_DT} as the default value of the field.
echo date("M d Y H:i:s") //Local server time
echo gmdate("M d Y H:i:s") // GMT
|
|
|
MFP
06-13-2008 07:51:09 GMT +2
|
Fred,
Thanks for your suggestion, I will give it a try
Regards
ManuelP
|
|
|
Fred at ExelWebs.com
06-13-2008 10:50:33 GMT +2
|
An extra tip...
Rather use <?php ?> than the short <? ?> version for the php tags.
It ensure your application is portable as not all ISP support short tags.
|
|
|
