RE: [PHP3] Insert Date Into VFoxpro Table By Using ODBC.

Hi, Thank for your suggestion. But I still can't update into VF3 table. I had tried the following date method, but still can't work. Can I using PHP Dbase function to read Visual Foxpro 3 table file ? Please advice. Thank. Regards, char <?php $connect_paysonel = odbc_connect( 'PAYSONEL' , '', '' ); $date = "1999-01-01"; //$date = "01/01/99"; //$date = "01/01/1999"; //$date = "1999/01/01"; //$date = "99/01/01"; //$date = "01-01-99"; //$date = "01-01-1999"; //$date = "99-01-01"; //$date = "010199"; //$date = "01011999"; //$date = "19991010"; //$date = "990101"; $sql_stmt = "INSERT INTO testing values('$date')"; ## assume my table only have 1 date field $query_paysonel = odbc_exec($connect_paysonel,$sql_stmt); ?> > -----Original Message----- > From: dgoa [SMTP:dgoa@ou.edu] > Sent: Monday, April 24, 2000 2:29 PM > To: 'PHP Mailing List' > Subject: Re: [PHP3] Insert Date Into VFoxpro Table By Using ODBC. > > My Experiences are that when you insert the date in foxpro over ODBC, you > need to > insert it in YYYY-MM-DD format. That is how it is stored. > > > let me know how it works out, > dgoa > > > > chchar wrote: > > > Thank for your feedback. > > > > Yeap ! I already checked the date format, it displayed in > > dd/mm/yyyy. But I had tried to add in the format as the displayed > > format, still can't work. > > > > Any idea ? > > > > <? > > $connect_paysonel = odbc_connect( 'PAYSONEL' , '', '' ); > > if ( !$connect_paysonel) > > {echo "error\n";} > > > > $my_date = '01/01/2000'; > > $my_name = 'ABC'; > > > > $sql_stmt = "INSERT INTO testing > > values(\"$my_name\",\"$my_date\")"; > > > > $query_paysonel = odbc_exec($connect_paysonel, $sql_stmt); > > ?> > > > > Error Message > > Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]Data type > > mismatch., SQL state 22005 in SQLExecDirect in > > C:\InetPub\www\IT\odbc_foxpro.php on line 10 > > > > Warning: SQL error: , SQL state 00000 in SQLExecDirect in > > C:\InetPub\www\IT\odbc_foxpro.php on line 11 > > > > TIA, > > Char > > > > -----Original Message----- > > From: Frank M. Kromann [SMTP:fmk@swwwing.com] > > Sent: Saturday, April 22, 2000 3:01 PM > > To: chchar > > Subject: Re: [PHP3] Need Help On ODBC Connect To Visual > > Foxpro. > > > > Hi, > > > > Try to select the date and display the result. This way you will > see > > the format needed ! > > > > - Frank > > > > >- > > > > Swwwing A/S > > Frank M. Kromann > > VP Development > > Phone: +45 70 20 77 20 > > Fax: +45 70 20 77 21 > > http://www.swwwing.com > > <http://www.swwwing.com> > > > > Name: winmail.dat > > winmail.dat Type: unspecified type (application/octet-stream) > > Encoding: x-uuencode > > > begin 600 winmail.dat M>)\^(BT!0:0"$`````!$0>0!@(```Y0``````#H$(@<` M&```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E#$(06P.```T<&!D M$P>#```!70$@@,#@``-'!@9!,&PK```3P$!"8!"$```X M1#DX-4(W,38V-$%$-#$Q.3@X,SP-CY-S-#.#9&,@#U!@$$@$.@```%)% M.B!;4$A0,UT@($EN<V5R="!$871E($EN=&\@5D9O>'!R;R!486)L92!">2!5 M<VEN9R!/1$)#+@T$@$-@0`@``(@!Y&*P,`L```P[@`@@ M!@`````P``````$8```4H4+<-`>#R""&`````#```````` M1@```!4A0`0``0``X+C`P]@@@!@````P``````$8```` M84``````+#Z""&`````#```````1@```#A0``````L/X`( M(8````,``````!&````Z%```````P!@@@!@````P`````` M$8```$(4``````#$&""&`````#```````1@```1A0````` M`,0H((8`````,``````!&```!B%``````'@!#@@@!@`````` MP```````$8```-H4`$``!```````!X1(((8`````,````` M`!&```#>%`!```0```````>$6""&`````#```````1@` M``XA0`0``$````````@$)$$``!!P`/<`'D.`!,6D9UD"#. M!P,"@!R8W!G,3(UTC(^S,V>@@J0#XPD"&-H"L!S970P'B'$P*#%0 M5G!R<=XR$5D.4/5$65]"H(R&P@.PEO#CUH*@76V8P!0"P-C$$+8&X. M$@P,S,+IB!(:2Q7"J(*AJ(!GA5!#@;BQK((0!<!Y"&$@<TAU9V<'D'1I MBN:"!"=0521L&W!L%0,@8P!P)P5=7!DD&%T92+@'1O"N,A"H!61C,@ M9%L97<;L!P0$.!D'D(@1\!:+<=0(0'&!O_8"=$\<'@!^!'`L(&(; MX1PS:QDD')1W!;!K&[9+D,;Y$<$'4D"Q4$A0,"!$8F$1$!IP=6Z^8QMR M'D=DEP'O%6!#"=0=($9O>!*@'9"_'C9)!Y3&G#$!U/QDN[R20'HE MA[P=@W@'I9)3YL"X`=0!HC*E89,U)E>F<+$7,9%1G@$-(9*CQ0/W!H<!DD M)6@;DLJ\"5P7PJP>7,"(&6)R](1P8F-?+P4*"G4$%94T\@3D5,)R`A M$"<G.3'"("D5<!DY"O,@)",=$S0(C$Y-#M,)HQ-&$B,FD?"\O,Y?]-'O M-E$T,#3&-:\T(C;?_S0$-G(TJ#=9.?\UNC1B.(__/1@X;SM&-&PW6S1P/X]" M1O<_;S/(0I$P1)\[@D*"-,JA+M%S<6Q?&V!M!4"!,_%)3E-%4E0<`+A.5$\> M0!M2(#%V!T"1"E!S*"<SDR<I-,#9&>C(RG@!!!U!X@H&9Y'D0P(&YL3*`0 MX'9]'4`Q(%0H$"_@"S$NLW%)"E!R>2]_97@%D"B=+O\L2+<R4!VE/SXR?_\J MP0\Q%Y$!0";Q'3E<!'D4#$V("U5PD\%$&?+"XFD4T'D'-A&T!5PU\9)E34 M5*$+$U36:3]0-,8T4JT#$X,%#-"M66-B)K#83H,@V(10!D9V]A(%M3 M3:A44#I;@D(8"X)@'QU71DE6I&8(P6O=-:P(@'1!Y(1!!$J#$3(>-"$0 M=!9\%\@.C(YY22035SW5&]:]S$0)+$N30MP*M$@0$P$'0G<5SX=6)J+T%: M]RQ.M-;P"2A,UT9X$D@20?051!TB9.`=@1X0)M14%2?#0DR@52133T1" M_D,K=U?O50)4)S0<$3=.L,1DS34R@12;@!G$)\/\J,0@"L=0!^'2`B M<!^0_P.@&L$=464#'X(=%1IQ)N/^;TV0!<!G8B$0;.(J\!]2MF\9)&TE:7#1 MZ!9<5'+4U-+41$&G(P/YT&[:$G#1!"@X?@</+_!";86P"8`K>QDD M'H%0/E,86MN<R%S%2*"!"(8/YT&15;@G0O&740T!#2(G#75-):\!DY/AH> M9F_!)/N8RMF4O5ZP%DF$'@?B$<0=)@),H!#0!9!KWQ]53>1R$R$0</%D M!`+40YY'U$+@7IU9&0O;?AM+WF!P1NV'ND=D![P_X"B'W5R(DP1;82-GIF M?W;/'#HB@WQM&>!!;DR@'5#_`0!;L"AE?,<N0(?X4*\P#Z\Q'S(IB%(&D"", M\"&*_^8IA_@9X5Q[!9@X#0IP20VM<%QN-,%]AX_:)$R07S.E&>`G-E1? M<CXGCFF3LE9@3&&,$"=!?V>`E3>*64C/2=]*XY(P(O^5]IJ1&1":I!T2FI%+ MH9</?T[O3_]1"I@(CEE2YGS'1?>1\E:6>F97"L#!@`9$"P4U%,()'C9$%- M#>!GV"+L&75MG8B9)4&TG40%$&[176516[!T=GEK8'IF;00`<C$0T"ZO M(1"DPAM@'2(R7W$U;A+GI,%K0`601&D)<"5P@+G:0UKP7&3@$2!08S"2,'9W MK1"L8522,(PS;E0N^RYA31$@*M,8('QMI#^E0?^I>E^!7Y&JGZNOK+^MSZ[4 M8Q<S?*E424$9%8A20_\M5X?ID015SU;=NBA:L[TS]1I"31NP2P-CZ!;U10 M7&M`^"U$"A+@6@;7]<Y;HH78/!(AT@"'!>BC+Y7U4S.C1P8`>Z*&#!*3-_ M>337V,UNC9D*0?'U%(^XO@?8!/`Z"F,PA0BR-@L7\F17IF)L2'?[HU&/?+ M[U3_G>EPA$0'H"S<6V7'?.^)1]S"7;$&QR41H@<N'^=]"1;.(#\!QA M$1"CIX/)^V^R'U$AS2^Z9;W4U(^1!)X^O%;%O[^D$5`O4[QO:[W]U/Y6),%E M39)'!W!X",-3^4"#@*O!D0"N:-*IP-U^A$4W-U]A^=H?87C?3K<VNC<7 MD]$PLQ[0D!P.C=0M1$NOYG_5'/1,!%BB#CG^2OY;.A[G_ICP>PED%D0"`1 M,#$"[_'1&0F>L9&>.H,61)5"0/\%D:0'T.H,8\P?7+4`W@LQT@&X$O M;R5P$2M&V#M)@%MD(RZ-T4E81PI'/X>"UU"E#QXJ.F&2H4D0(](#"X M`````L@!```'@!P$``V```6U!(4#-=("!);G-E<G0@1&%T92!) M;G1O(%9&;WAP<F\@5&%B;&4@0GD@57-I;F<@3T1"0RX```"7$`0`!L M``!OZVV4.%)0Q\6&9<1U(!$)GG\7A#%24^H0Y+28TB<.W[\!`P#Q M/PD$``>#%`0`"\```O3SU-24-23TXO3U4]0TU3,#,O0TX]15A#2$%. M1T4@55-%4E,O0TX]0TA#2$%2``#!I`````!X,$!``+P``"]//4U) M0U)/3B]/53U#35,P,R]#3CU%6$-(04Y'12!54T524R]#3CU#2$-(05(``, M&4``````P#]/^0$`#"8``````,-@``````P"$/____\"4<0` M#,`!C/553.V$](#MP/4UI8W)O;CML/5]#35,P,T580T@Q+3P,#8R-C`Q M,ST.%HM-C@Q-``@'Y/P$`!+```````-RG0,C0A:M+D("LOX8(! M`````````"]//4U)0U)/3B]/53U#35,P,R]#3CU%6$-(04Y'12!54T524R]# M3CU#2$-(05(`!X^#\!```!P`&-H8VAA<@'@X0$``O```+T\] M34E#4D].+T]5/4--4SS+T-./4580TA!3D=%(%5315)3+T-./4-(0TA!4@` M@'[/P$`!+```````-RG0,C0A:M+D("LOX8(!`````````"]//4U) M0U)/3B]/53U#35,P,R]#3CU%6$-(04Y'12!54T524R]#3CU#2$-(05(`!X M^C\!```!P`&-H8VAA<@'@Y0$``O```+T\]34E#4D].+T]5/4-- M4SS+T-./4580TA!3D=%(%5315)3+T-./4-(0TA!4@0`',!BSQ9T(W[\! M0`(,)RF';H-W[\!'@]`$``%``4D4Z(````>!T.0`#8``!; M4$A0,UT@($EN<V5R="!$871E($EN=&\@5D9O>'!R;R!486)L92!">2!5<VEN M9R!/1$)#+@```L*0`````"PC``````#8031K9T,!Q!Y!P`P0 M$`````#!$0P`!X"!!``90``$A)+%1(04Y+1D]264]54E-51T=% M4U1)3TY"551)4U1)3$Q#04Y455!$051%24Y43U9&,U1!0DQ%24A!1%12245$ I5$A%1D],3$]724Y'1$%414U%5$A/1"Q"55135$E,3$-!3E0`````2H\= ` end