date:20030819

Re: [PHP-DB] Query runs fine on Console but not in PHP

2003-08-19 Thread vish.kohli

Thanks for your response.
My script is running on Linux. I am trying to retrieve simple data such as
text and numbers.
I am not sure what the TDS protocol setting should be. What are the typical
settings and how can I check it?

Would appreciate any tips for debugging.

Thanks.

- Original Message -
From: "Robert Twitty" <[EMAIL PROTECTED]>
To: "vish.kohli" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 8:28 AM
Subject: Re: [PHP-DB] Query runs fine on Console but not in PHP


> What platform are you using?  Since it appears that the script is
> crashing, you are probably on Linux or some other UNIX flavor.  If this is
> the case, the TDS protocol setting may not be correct.  What type of date
> are you retrieving with this stored procedure?
>
> -- bob
>
> On Sun, 17 Aug 2003, vish.kohli wrote:
>
> > Hi,
> >
> > I am trying to execute a stored procedure in PHP via mssql_query ()
> > function. I pass 8 parameters to it.
> > The query runs fine in SQL Query Analyzer but when I run it thru PHP, it
> > behaves strangely. I can get number of rows (mssql_num_rows()) and
number of
> > fields (mssql_num_fields()) in PHP, but when I try to execute
> > mssql_fetch_object() or mssql_fetch_array() on the same result
identifier, I
> > get a "Page could not be displayed" (standard internet error page).
> >
> > Please help.
> > Thanks in advance.
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] [SPAM?] [PHP-DB] Re: That movie

2003-08-19 Thread Joe Walker

Actually, the attached message was sent from a computer infected with a
virus.  There is an unusually high number of messages that fit
symantec's description of some worms out there today.  My best guess is
it is one of these two worms.

http://securityresponse1.symantec.com/sarc/sarc.nsf/html/[EMAIL PROTECTED]
html

http://securityresponse.symantec.com/avcenter/venc/data/w32.hllw.kickin.
[EMAIL PROTECTED]

Joe

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 19, 2003 8:23 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] [SPAM?] [PHP-DB] Re: That movie
> 
> This mail is probably spam.  The original message has been attached
> along with this report, so you can recognize or block similar unwanted
> mail in future.  See http://spamassassin.org/tag/ for more details.
> 
> Content preview:  Please see the attached file for details. -- PHP
>   Database Mailing List (http://www.php.net/) To unsubscribe, visit:
>   http://www.php.net/unsub.php [...]
> 
> Content analysis details:   (5.20 points, 5 required)
> NO_REAL_NAME   (0.8 points)  From: does not include a real name
> INVALID_DATE   (0.6 points)  Invalid Date: header (not RFC 2822)
> RAZOR2_CHECK   (2.1 points)  Listed in Razor2, see
> http://razor.sf.net/
> DATE_IN_PAST_06_12 (0.8 points)  Date: is 6 to 12 hours before
Received:
> date
> MISSING_MIMEOLE(0.5 points)  Message has X-MSMail-Priority, but no
X-
> MimeOLE
> MIME_BOUND_NEXTPART (0.4 points)  Spam tool pattern in MIME boundary
> 
> The original message did not contain plain text, and may be unsafe to
> open with some email clients; in particular, it may contain a virus,
> or confirm that your address can receive spam.  If you wish to view
> it, it may be safer to save it to a file and open it with an editor.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

2003-08-19 Thread Gerard Samuel

Matt Schroebel wrote:

Gerard Samuel   wrote on Tuesday, August 19,
2003 2:32 PM:
understand on a fresh database startup, it takes time to get things
together to run. But sometimes it would seem like its going fast, then
othertimes, crawl
slower than snails.
   

I've found that, with an AS/400, I had to build the proper indexes, such
as an upper case only version for performing LIKE '%LASTNAME%' searches,
*and* tell DB2 which index to use on the SELECT statement such as:
SELECT MMLNAM from ADDRBOOKL2 where MMLNAM LIKE 'SAMUEL%'
If I didn't point the select to the index, for some reason it wouldn't
choose it.  The folks at IBM Rochester Support Line told me to do this,
but it seems to me that DB2 should be doing that leg work for me.  It
did decrease response time from 4 minutes to 5 seconds -- which is still
slow.
My biggest problem with it now, is that it seems it runs out of breath, 
every so often.
It would be fairly quick, then slow down, then pick up the pace, then 
slow down.
All this is run on a 1800XP/256M Ram Development box, where Im the only 
one accessing the database.
I would even go as far to say that MSSQL is faster than DB2, from what 
Ive seen so far...

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sobig virus

2003-08-19 Thread Peter Lovatt

Hi

I have had 40+ virused emails to the address I use for this list. Possible
they came from another source but this is the most likely.

Please check your virus scanners are up to date - 2 day old Norton virus
definitions did not pick it up.

Thanks

Peter



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Problems with input and modify data on a form.

2003-08-19 Thread José Luis Palacios Vergara



begin 666 formfill.zip
M4$L#!!0(`-<*!R\H$P'/[EMAIL PROTECTED]&0!```49F]R;69I;&PO86-E<'1A
M;6YXNJG^
MQ<:XIZM"'R_Q?3#7Y=XTF]O]QC<[M*\U*EVIEKI4J7"Q1/!\+N>9-(9_C$P,
M>('B3Q96$091!AT0!V0G`^M#A0*7D,QY&:O6K9&4;=BHQ'CI7L#%.RL=ETUN
M*$B:9*.B=H(Y5<>6B?OR8\>DH8E)+X KX7BT
M[(.I&[EMAIL PROTECTED](\B8V\_AS\S(S"C9P"Z<+5>05<@3:.9B;"W([EMAIL PROTECTED]
M(K."%XGP%3!.+"T3B4R(6:)6P+UU:> 2_T"A&KY5Q6M%3+;.:JMI$)AES<_G
MS\G'Q)2>)>S/Y;AZ[8W-G?%.22L9>?P3K(69]J>DW#RH[>:AZN6QRUWMJL?5
MM>%O-7?]T1),^<,;6YXNJG^Q<:XIZM"'R_Q?3#7Y=XTF]O]
MQM<:E:Y42UVJ5+A8([EMAIL PROTECTED],&L,_1B8&0D#Q)PNK"(,(@PZ([EMAIL PROTECTED]
M<.:\C%7KUG#*-EP4M>WI++QM5&5F$
ME\Y;KFYBRN(1%K%L$Y_J*J;Z0[MTW#RL^"R:_4]=UA8PNG)[EMAIL PROTECTED]
M&:P!4$L#!!0(`# #""[EMAIL PROTECTED](``#L&```39F]R;69I;&PO9FEL
M;&EN+G!H<-54;6_3,!#^O$K]#X*F`4=8VWBN^X) D(L(18D(D?."1A'+
M9EI;R;[EMAIL PROTECTED]'.A-7TWOOW2KN3V5TT=BRW-
M.8 [EMAIL PROTECTED](7><[4-&:,[EMAIL PROTECTED]<
M1E> H+I8U]8FXD%+S%7$9,&IN9*JN^\>D)S
M[$"EZORA.G' *V,:5C#=MGN_"[EMAIL PROTECTED]<9EC?PD.<2+7O_IOJU
MUQ35V-%PT#-6>J+Z"VI1135]OWE:<_9WJOX+AM:'W!)3O^G1FI%]-O1";#O2
M8]FQ>V7#JSIHS[30JJM6??P74$L#!!0(`#."[EMAIL PROTECTED]
M9F]R;69I;&PO9FEL;&EN9G)A;64N<&AP;5#!3L) $+V;^ _C'[EMAIL PROTECTED]""
MVM;[EMAIL PROTECTED]@6"-\5C:A6[2[M;=T8)?;[M+/7F:>>]-WIN9X&*VBI./]1R>DI<%
MK-\>%L\Q, _Q?10CSI*9$\;^8 B/.JVXX80X7S)@[EMAIL PROTECTED],?*7WF&RP
MH*H>4L^C\+.AH6WF:=Y4$E3QZY27/*$"'6KKBE$+GZ_'/+_$=LEA)
MXI*\Y%AS!IE#(2-^(!MU!UF1ZC8I%$9YT^GDQAO:0#PEM6V_#&C5F)!=3ZXN
M&5ARJW3.=]6I4(Z.WM/?T4'I'(H"K8J
M/[HKT;8!_FGV">[MOU!+`P04" [EMAIL PROTECTED],[EMAIL PROTECTED]@```&9O
M'&<*.U.,AYIK)I7P`3#7P4:K
MU6T:+?E0*3XJ45C9^L ,--@)W^H^YPEG:-T)FL(W7:,ZP0ITJW X&[EMAIL PROTECTED]
MD*OID;R3NB^]*(#4JJ.8K.O6!/7;.0Q"_N*; C^,S?O<8#>,S
M3=0TPY]02P,$% [EMAIL PROTECTED],(+^:[EMAIL PROTECTED]@[EMAIL PROTECTED];W)M9FEL;"]F
M;8P;D4"N)_QVZR$5 KP6A>[/O>#]_'L6[T=+:<1A]7<[EMAIL PROTECTED]:Y@
M]?[BZNT46)_S#\^GG,^B6>UX$9P-(+)"EY*DT4)Q/G_'QJ3Q1PNEE&T7(QXK3FGDOH.+*J0E;156&:(Q("V!8:,\"OQN"P99!;3
M)[EMAIL PROTECTED],D01D1$4?/U=R$[*IT82:^I%+9A#75E/%]S2$.!.V1 IE:?KGYR]?
M]0>[2KSIU&W7)MF"PI1R86^E#MDSUXPI6E:]_2(3REIVAO(V([EMAIL PROTECTED]
MN+/8IQ)5RD#$_II"YC*0,I.$;+6\B1AHD3O491$[+SI4EP_^&\6N>[2[MJ#Y
M1E(7%34IUTC6Q)[EMAIL PROTECTED];^O=45DM+/\Y?X>L!&J^D-:&^O6D)TQ`*.G2L9W(2N$
M=<<&J75'E$$NI+[TVR Q<97O/ YM$-0P05VU4UC<=(9_F5I6ZUQ2MS=DXP-@
M"Y/(5,;"];@[EMAIL PROTECTED]>6^YO:(8',E\':P;,@^&0C]+<::S]X.^ >_$$[
MWD/5;A0<\7_>""[EMAIL PROTECTED]@M0,:K$8Z'I.;?8]D.CUYXH#XPYP9<1]4ST'N!V$]
M&^MI_A-02P,$% [EMAIL PROTECTED](+Y+HJ#>)##"P$``!D```!F;W)M9FEL;"]F
M1 @M1*M,W!"/7H
MAD6V, [$"R)_W[S4T\S.[HQFD^?B.U<_Y0;>U><6RMUZ^Y&#D(C[18Y8J&)<
M+.&S&Y#TH4>V["A+<,1.<-:?H"&7BL"MHV"(
M6 "W%TH%TX.Q"D& :>@X7>B348YHNDZ\W>4Y'7GLFS5)U90#5.4TK?
[EMAIL PROTECTED],*I74=_ZT,[2/]D^N /4$L#!!0(`#2"^2X@
[EMAIL PROTECTED]"H!```79F]R;69I;&PO9G)A;65R:6=H="YH=&TM3TU/PS ,
MO2/Q'TSNG3T&]N]/FW4.(D'\N,T1"UF,PMUD.@/9*><-F]8IBUB^BL7U5:JYL9=)
[EMAIL PROTECTED]:/!^6VQ(.ZY>53'&D!LT:]PT=V4QX[BUY3<0"N#]1)IC^&"OO!>B.
MOJ)C$HB0;(@5:.930C]G\YN)O'5,CA,YA 54XQ9;PDF/4&G5>>+,^#:9S^\?
MDMFE">.A`_QLZWY R_Y<[EMAIL PROTECTED];%%..#_U!+`P04" `U#0,9U('```]& ``%0```&9OZ.G%SD:B9C!//M,U.,XF;=XB$),04P [EMAIL PROTECTED]'[#_T' `D
MH0LM>=-99A(1!^=^PR$R7IAE-CDY'B\83?'7<).QR?6'U_]^2VY^>S_N.P#L
M9%S<$L6R.-+F+F-ZP9B)B+G+61P9]M7T$ZTCLE!LYC%Z"$#*)3.4+(S)N^R/
[EMAIL PROTECTED]@!Q1!*W\EQ0H1%)%E1I9F*N9??%B\N7W:'E]/'JP\_O;TA&
MQ;R@ZCE:]/F9^1)3%KPY_1T![S7`.^V2H;[EMAIL PROTECTED]&%"&#\*1%':'>H%(G1
MG-)*^]",*=,&KR_SC!E&C$RE)AG\3:F1ND-RL'M&5U+UHE*28J90`J"99A;T
MS0D"">D*I*.D?.$BE5]ZJ4R*)11Q[UJJ99%1Q67OS:?>
M#,"Z?1BN9AE+3/NA!-P9TG\RK!C5!%.[#BOH-Y<0V:3N!G4^NLTQN2![W9 NEA26 _P'5R#C?+"[=CFSN.PJW>'V-C)!/[EMAIL PROTECTED]@9V9^-9DS^A:P=
M&BJ.1< FM2RD_DN&P] 6 XWCH&7H3;UNE_VN4
MP3K*H$()+$E7'/:&PRY0A-@(+WM5F!FX^P2W>T:^DU^8NJ*:M<]VI?C;=P3R
MCH -7"12*.7.:H!Z'.=P/$^0H;&H_!TT-
M"74-N'>+ 
MNA\>$$7?"TO^[K<>LK8GUJJMU3.K)6J>6MWVKKEUUTZO<2><7;='UPV*T9I5
MX=A:'JZAUN&)\+CS%5O1__-\_8X65!_'[EMAIL PROTECTED]/QC :! U1"D:-NQ$
M%XTD3QMWGC4QNVPD^:EQYWD3LQ>-)"^;2&X;27Z-RBR]+Y.U/[EMAIL PROTECTED]<,W.[S
M)Y5$2&*/,)U+D3)"<0#&C-J<>!^94H]-JD>GU8[$\L/RM[IO< %#O $[=K6.
M:C[K?+8Y.(G=.-3Y''2/@$'[EMAIL PROTECTED]&LK/[EMAIL PROTECTED])R^96\=J<(;?8G43@
MV#G8L&$(NE^ UF-KBRV>6OVP@"QY3)YN9<8.B;U6Y6/@A0?(028$G^M.V6$8
ME7 B?$#X'JY6G8IG.;X]&.4T[+)AM"_6HGV$;DHWRPD'@5OLJ4='3:D`Y88N
M0NON'\+;Y#W:C/ON\LI>5(W[_KX-7I]TN^.I3._(=)Y(:$EQ],.U?2*2L9E9
M0CYS8;N\D7FP&H6P7K!^'QA+$"*=Y*F<11-NETG"BBOZG^\ CJ*)Q#IV8
MST$FRHHF;J)DV'!?D3$7.7P*UJQ*R3AK$LW_A->AM?BK2V:[G(RG$T*ZX_YT
M4M8)/HW,WGPJ>5VLLT+/72VHF+-X?1#\QZ;UX9EWPZF8ZGSD_AU3[ZP?K (9
M3V[C:"&-#1HTAFV&>[EMAIL PROTECTED]%0:LZ>/"*TX(F
MA6&C)5.2E N+^0?4,D_!$_9."LYI?YU)-*MP?)R663A-CTB:WU$$Y:#
M';TYGT7$5^R+_X_#?X&4$L#! H``$^V#2\`
M```.9F]R;69I;&PO:&5L<"]02P,$"@``3[8-+P``
M`!4```!F;W)M9FEL;"]H96QP+V-O;75N82]02P,$% [EMAIL PROTECTED];;Y+NWITRFL
[EMAIL PROTECTED]@4``!\```!F;W)M9FEL;"]H96QP+V-O;75N82]F:6QL:6XN<&APM51M
M;],P$/Z\2OL/AU?6%*UO2$B#)JU&UPTD6*4R(2&$*B>Y-)Z<.+.=EL+VW['C
MK-E \ U+B7WV<^=[_)SM3P];[3A,(8!LIV[Y*A)

[PHP-DB] Re: Problems with input and modify data on a form.

2003-08-19 Thread José Luis Palacios Vergara



begin 666 empresa01.zip
M4$L#!!0([EMAIL PROTECTED]'[EMAIL PROTECTED]_/Q
MVG'QZF?_Q7_PN^W-[1\WMPS^/K[Y\)X%*WB>_^SCW?7[U]>WKW]X],.COA73
MX_Z&,_8EN^M_O+UA'^]N/[VZ^W1[P_[YX9;=T=SC5V_?W/QR_<>;QW3I#X]R
MK1K6\74IF-PP\;-LNY;].ESU*]PUTX)WPEXSG6%/'C'VJ_YT]RO[X_KVU7]<
MWSY)G[):=:SNRY*]OOGG]:>W=^SQXPN\KO[P[A?SJM/ED?.MZU]]N)W=WOO*
M]=GUV[<*+B
M[X;O>Y_KLP[M/[Z_O1ZCBS>WLK?TOW_6%N+)R]82&
MIX^>LNZJ$?]>_4NVO+)R;B4=M?/-^]_8:]"_KXFYK%NA.R;K3AW(,#WAXD ^
M+PZD[V*0K8NYY%R,0G(QBL#%R.>+B9,7EET7!\RX."#UQ4C("TNFIVS'RUZT
M3WY,HCAU(L?Q?KQ@/_)"JTQ50F>2EPP^R0S&=L57]BQ^QD/19KR693I7
MK.5=)TJAV3/&2W'):S JK(3GJ_&[EMAIL PROTECTED]>,"?\*'!=QPD'3NQ$Q\HNYZL+
M!OQ8&7XHH/[EMAIL PROTECTED]"RYIKR6=7T^$.OL#:7NXY\U*ZEQWF_,[EMAIL PROTECTED]/-]U
M$X?F7LIRHT7.MD#,O6 O1;F7HJ+'Z JXH%A6]K5H6;E:$"/"U/'2-+",`&T`
M*:[EMAIL PROTECTED]/;[EMAIL PROTECTED]>.WU**V/4]AY1BS37\RUFO
M]ST'G4!%JWA12*6)WQ77&3Q#JTO>/N]KV6GX!$ITR=GP6N8!CN]Z#YX?:>R@
MA7([EMAIL PROTECTED])P(IZ)W0KE>4!77&&&[EMAIL PROTECTED]&%&HP4U4.X,*Z(TBB*?
MYLI>MDS46O[4"W;[EMAIL PROTECTED]:[H#!"[EMAIL PROTECTED];(D%VU2M<*
M[ _(([EMAIL PROTECTED]>Y`*EUC3.QPZ'9^0+!0?83-R+&&(<@YS;\+5$
MPP=NIT`UD;E9[EMAIL PROTECTED]"(COIX
M]&T'_J!EJ4<[EMAIL PROTECTED]([EMAIL PROTECTED]/,L0'Q _?48&U$NBJ#?]NI29S'D.
MCKCA'1@:O$SHG"^(]$G@)A$0)":B<5V HS0D-]YX-HV''00O$HV,;PR&'>Z)
MA*(T=9V !'\#TDP^5;0-_\Q9IG1G+-KAF?W\U$)HSKPX]CTO\2UQ`9FP+6 4
M-"D%\HH[A#Y2R#^E>[EMAIL PROTECTED]@":W!:
M#YH+J9<@&^A'P=N#!;[EMAIL PROTECTED]:TH>FU8L@/1''D!X.7P&X=\B0*'-;)5S"6Q
MAX_?P1WP/#' 5?P\.67>@G2P2M67XIG(>PJCD0L7.Q.2N\: X=_A]##K1#Z8)L_U8Y<4:R>S
M3FD(-0I1KL'N=< \8)?.\63^]\<0\EVQ)[EMAIL PROTECTED]'I#YL[
M7NSY$W<@J#+J`U8-)+8&[EMAIL PROTECTED],9*X=^$$"C"KE$ZGM\&4<
M<*1,[EMAIL PROTECTED],8 ,"/[EMAIL PROTECTED](EW_S
M1(_="J0?M>>R1]ET(X^^/(SW]S%>Z%.\4\ELRP6";B$Z=#.ZP6D">*"68+!V
MHI3[9_:!ET*;,'$I+/ ]-W9L1)9+,.1RW4L0?TY$KQ1,[-E RM$LY9(;+<@4
MV/[EMAIL PROTECTED] /L<$\^>)Z'V1;\O!;U)0>CYE\*H
M* [EMAIL PROTECTED]'/U4I24)S%0>-2*87[B3=L+@&L0*A*![3#G1J,[EMAIL PROTECTED]'RF(
M[T(41(9J#,PI!\)*C/8D*<=4IN"Z0BA6%TNBO!N3DR#*B:HA7PV6.4/T2=$N
MX-V-5H1X[0$YV]FAU9 @H)O8P208#X_FD"E R.3[H3^'3 BT2U9((']N4[!S
M3>!7O+38R[%J^+#S4X#%`]>&(0/Q;6JNPXH0X[5HLLDQ''W<[EMAIL PROTECTED]"!L8
MWK?A(+<[EMAIL PROTECTED])-L*GT,[EMAIL PROTECTED]$X%BBAT__R$\QC# 6
M8+5=&(?"O`-Y"0+#FV5B16P"+4M_#9AB36I9UWE>J.TX+6:[EMAIL PROTECTED]
MMQ72T*=OV^%_.BF403"B&:_ 3#V_Y-E/O<#>*&PI`*-E[[R,[EMAIL PROTECTED]@0^,(9?-=]A,/ [EMAIL PROTECTED]&Z &Y>W 
MBM6BK\ V8=L34V5S#?=Z]I<`9N)8D_XW!F[EMAIL PROTECTED]"(XG: C"4!V>VKI=_*SJ?E7)JHC<2V[TQPHFPA7"M4H
M[%.RST7/4W8&>G6 CABM<9([;%3B0WNE`NE?4GHH]9S4';[EMAIL PROTECTED]
MI@:3(7QO<76)'X:&_':<"SJZ@(X\K=DB]3 )E*;(/? F&MHD*+&P'
M/V +EF=E>[EMAIL PROTECTED]@]991!K38:R<.`4KM"8>ZGF=KQ]YWU8X3U_5]*R%:
M(K/-VV13C;CA:V!"#V 9M+ 8@<\2PC(0S3$:`#^9]QG6"&RA5DSQ\9ES-'TF
[EMAIL PROTECTED]&>T4"<1P#&B*N:F"ZFKU!H7)%"TB&MCQPYB)?5+T&0M4$8,\+2^B=
[EMAIL PROTECTED]"!A"Q,0Q+98;PWRO>"R(MHCY(_V!@,C@"]8B_,-#;P0,E%G
M^Q7#FJUH1RV [EMAIL PROTECTED]/81'S7-.P.XSW1CU^F)C.E2$2R'0/
MSA9S?O2X80WGT#K-GE'=8(W-8=OG]%9/%Z0B$(SA8G*[!G,KQC5L(Q]PSO !
MW0`89= 2)%#HA0[+9(\Y`IO8UM*$7^G8(['M1;8%8[8^GX'P8R]Z+$'/B:^$=N8I.IU25<4(O]IK36H.A7XZ2P"T?VMV-H-O$]'^O28YX__^S20XBY00C`6\@/! <2TW[7!CY/C^[
M&$>0QN$0A"'QV5B7(:I<^T
M;'"M:E5AAQ"X>YH\[LYZ3KFEZ;HE<2$*HS2.;*^5RB1E?6><,(V"F*B9$*J=
M(>D^[F9Q';LMR'AP4+8>:1349:%J'C2V94F8#"\.LP_S0,R8+
M6I=E5KV3+S?W=:(EM/ &@9,.V:(6D#ON7L&FJFXIKCJ80-699_/L!<-Y(MQN
MM<[5BLVQK&?"D&'$AKB"V]9_[,7=E$;7CNO+;N@&[E%]V;Z)F5 FL&@`0(,X
MJ'8(R)W0I ,?-D_<@$)H2EIT6P!*5WDMKK!I`M,/JY/2S=$UAAL(I< I`/8%
M'[EMAIL PROTECTED]()H&-I2J%/49/[EMAIL PROTECTED])P%4+MA#>$(/&E_10PJS-PA8\85H[2D.C
MV "/ZK:A#0XPM8W+OK&N,E+]Y+1)G6'2M &/ZL4A2?TP?D?\$)DM`PI<[,,T
[EMAIL PROTECTED]@29HRV7Q^4:GK",*VP#[EMAIL PROTECTED];@
MR&?]('8&A['SEGX?6G%-/9_,C8V%C[]'Q)D?)[EMAIL PROTECTED]>VH9T:
MMMJ3>0K&XH]&BS-=:70`IC$H1NGN
M((I;;;20V)=8_\D"SR8OX)_OX4SL)K&IP8&1*4NA*V3W/N.H$F)OMMHCQE%%
MQZ[P8 4O=Q YX[Y?`YL6D+E(7/ %H8%*/@(#*.KX#3FUE
MO6]PKSYKV9;C,K &; *\V4X)8,;[\KA5'J_9=>1 -A(#:M4)W)W034,33=CQ
M7N[#\T/[EMAIL PROTECTED]'&(%/80*U;@IHFG4;[EMAIL PROTECTED]&$O[);B.U'?)[EMAIL 
PROTECTED]
M?K$T6500?'30VBY0.#Y/GT][O4R1TW4,[EMAIL PROTECTED]/Z4\HQ=^!);[EMAIL PROTECTED]
MW")@15_%A(@-(HO:8"Q-S:+^]#Q#3O;[EMAIL PROTECTED]/J"U;Q31K?.
ML<1F;UN)BX&&'.$B=GN)0C]U$I/CMPRQ.WIN90,N(B.H<\*/-<1Y8$4ZP,"$
MX^QP/^<1NI%=WFP#BP;DG/6 JVUVY P': -0VZXVUF,?>[EMAIL PROTECTED]<4 <&=(CB"W'
MW8XXYA9:[EMAIL PROTECTED]>834N9X3AU7+M?E2F;GBC$%WF ?T._.V;U>,<4>)>"VYB'
M6H>)YHTRS1C)/$Z[^H'IJAX/#M*N7UQ(B)>3
MN=OVQ;S_B'KOX [T=;.,4!D!SVP;TF)[EMAIL PROTECTED];@727"I0>(C?Z
MQ<-X;V$>3?IT\V'Q(9X>0 \6HZ\8QSP\SZ?>HR4(MN,FV'=MRF,0JF'9'QM;
MS%:!IQU'IQ#T3R!_8/M?S#C\'=*:E\8PO^ M+J)I^9K3MBH3<&E =P!,=B-]
M'WZQ('4"UQ]6FHV[UF4"P#[\1P*Q>[EMAIL PROTECTED]<&68KW1-5Y%[VEPT
M1;QC(6W^QY:Q;C).W,CW4A/]48J'ZL&82E[!?RO<[EMAIL PROTECTED] $:SZ)
M$UH9"6RTZ%3'/".TW^C9.D_1*9/]L-4_]3Q,UR0C;2E]]G^R,.(TC

[PHP-DB] [SPAM?] [PHP-DB] Re: That movie

2003-08-19 Thread oracle-l

This mail is probably spam.  The original message has been attached
along with this report, so you can recognize or block similar unwanted
mail in future.  See http://spamassassin.org/tag/ for more details.

Content preview:  Please see the attached file for details. -- PHP
  Database Mailing List (http://www.php.net/) To unsubscribe, visit:
  http://www.php.net/unsub.php [...] 

Content analysis details:   (5.20 points, 5 required)
NO_REAL_NAME   (0.8 points)  From: does not include a real name
INVALID_DATE   (0.6 points)  Invalid Date: header (not RFC 2822)
RAZOR2_CHECK   (2.1 points)  Listed in Razor2, see http://razor.sf.net/
DATE_IN_PAST_06_12 (0.8 points)  Date: is 6 to 12 hours before Received: date
MISSING_MIMEOLE(0.5 points)  Message has X-MSMail-Priority, but no X-MimeOLE
MIME_BOUND_NEXTPART (0.4 points)  Spam tool pattern in MIME boundary

The original message did not contain plain text, and may be unsafe to
open with some email clients; in particular, it may contain a virus,
or confirm that your address can receive spam.  If you wish to view
it, it may be safer to save it to a file and open it with an editor.

--- Begin Message ---
Please see the attached file for details.
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php--- End Message ---
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: That movie

2003-08-19 Thread oracle-l

Please see the attached file for details.
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Queries probably timing out

2003-08-19 Thread Micah Stevens

IF it's a linux server apparently there's a glibc problem from a while back 
that causes this. Check to see if it's a redhat server. If that's the case, 
all you can do is get your host to upgrade. Or host your own server.

It's starting to sound like a OS issue after searching around on google. I'l 
call up tech support and whine until they did something, but that's just me. 
:) That query isn't that bad. 

-Micah


On Tuesday 19 August 2003 10:54 am, Dillon, John wrote:
> I set set_time_limit (10*60); high up.
>
> Error message:
> "Lost connection to MySQL server during query"
>
> Query is:
> $query="CREATE TABLE IF NOT EXISTS $tbl1
> SELECT TestData1.Year,
> TestData1.Period,TestData1.Co,TestData1.Acct,TestData1.Dept,TestData1.Descr
>i ption,TestData1.Net,TestData1.Net*.175 AS Exps175, TestData2.USD FROM
> TestData1 INNER JOIN TestData2 ON
> CONCAT(TestData1.Journal,TestData1.Description)=CONCAT(TestData2.journal,Te
>s tData2.description) WHERE TestData1.Dept<>'D1'";
>
> Thanks,
> John
>
> -Original Message-
> From: Micah Stevens [mailto:[EMAIL PROTECTED]
> Sent: 19 August 2003 18:00
> To: PHP-DB List
> Subject: Re: [PHP-DB] Queries probably timing out
>
>
>
> What leads you to believe that it's a query timeout? Is the php script
> timing
> out waiting for the database? Do you get an error saying something about
> "Max
> Execution Time"?
>
> If so, you may want to set that higher in your script. Go check out:
> http://si.php.net/manual/en/function.set-time-limit.php
>
> That's not a small database, but it unless you're query has some CRAZY join
> action in it, it should pre fairly speedy.  I've never seen MySQL time out
> though.  Even with some stupidly slow queries I've done in the past. So I'm
> guessing it's PHP.
>
> If you get an error, post it on the list.
> -Micah
>
> On Tuesday 19 August 2003 2:59 am, Ignatius Reilly wrote:
> > 
> > - Original Message -
> > From: "Dillon, John" <[EMAIL PROTECTED]>
> > To: "PHP-DB List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, August 19, 2003 11:47 AM
> > Subject: [PHP-DB] Queries probably timing out
> >
> >
> > I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows
> > in another..  I think the queries are failing due to timeout on the
>
> server.
>
> > The server is not dedicated to me and I may not be able to affect the
> > timeout settings...though I'll ask my hosting company (Positive
> > Internet). If I decide to do the queries on my local PC (I don't need or
> > want to do them over the internet),
> >
> > (1) do I have to set up my PC as a server,
> >
> > Yes.
> >
> > (2) if so what's the quickest and easiest server to get started with,
> >
> > Install Apache, PHP and MySQL. There are countless tutes on the web on
> > how to do so. It is a breeze under Windows 2000
> >
> > (3) are there complications running the server on the same PC as the
>
> client
>
> > applications (ie my PHP code),
> >
> > No, except maybe performance
> >
> > (4) do I then download MySQL and PHP onto it, though I read PHP comes
> > bundled with MySQL,
> >
> > PHP has an API to MySQL, but you have to have first a MySQL server
> > running
> >
> > (5) will it become clear to me what host name/IP address to use to
> > connect to the database (up to now I've been told by the hosting
> > company).
> >
> > You can use a dynamic DNS set-up (look for instance www.dnsmadeeasy.com)
>
> if
>
> > you need a name-based address. Also a breeze to set up.
> >
> > Any other suggestions on timeouts on queries?
> >
> > Thanks,
> >
> > John
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > http://www.cantor.com
> > CONFIDENTIAL: This e-mail, including its contents and attachments, if
> > any, are confidential. If you are not the named recipient please notify
> > the sender and immediately delete it. You may not disseminate,
> > distribute, or forward this e-mail message or disclose its contents to
> > anybody else. Copyright and any other intellectual property rights in its
> > contents are the sole property of Cantor Fitzgerald.
> >  E-mail transmission cannot be guaranteed to be secure or error-free.
> > The sender therefore does not accept liability for any errors or
> > omissions in the contents of this message which arise as a result of
> > e-mail transmission.  If verification is required please request a
> > hard-copy version.
> >  Although we routinely screen for viruses, addressees should check
>
> this
>
> > e-mail and any attachments for viruses. We make no representation or
> > warranty as to the absence of viruses in this e-mail or any attachments.
> > Please note that to ensure regulatory compliance and for the protection
> > of our customers and business, we may monitor and read e-mails sent to
> > and from our server(s).
> >
> > For further important information, please read the  Important Legal
> > Information and Legal Statement at
> > http://www.can

RE: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

2003-08-19 Thread Matt Schroebel

Gerard Samuel   wrote on Tuesday, August 19,
2003 2:32 PM:

> I understand on a fresh database startup, it takes time to get things
> together to run. But sometimes it would seem like its going fast, then
> othertimes, crawl
> slower than snails.

I've found that, with an AS/400, I had to build the proper indexes, such
as an upper case only version for performing LIKE '%LASTNAME%' searches,
*and* tell DB2 which index to use on the SELECT statement such as:
SELECT MMLNAM from ADDRBOOKL2 where MMLNAM LIKE 'SAMUEL%'

If I didn't point the select to the index, for some reason it wouldn't
choose it.  The folks at IBM Rochester Support Line told me to do this,
but it seems to me that DB2 should be doing that leg work for me.  It
did decrease response time from 4 minutes to 5 seconds -- which is still
slow.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Programs

2003-08-19 Thread José Luis Palacios Vergara



begin 666 formfill.zip
M4$L#!!0(`-<*!R\H$P'/[EMAIL PROTECTED]&0!```49F]R;69I;&PO86-E<'1A
M;6YXNJG^
MQ<:XIZM"'R_Q?3#7Y=XTF]O]QC<[M*\U*EVIEKI4J7"Q1/!\+N>9-(9_C$P,
M>('B3Q96$091!AT0!V0G`^M#A0*7D,QY&:O6K9&4;=BHQ'CI7L#%.RL=ETUN
M*$B:9*.B=H(Y5<>6B?OR8\>DH8E)+X KX7BT
M[(.I&[EMAIL PROTECTED](\B8V\_AS\S(S"C9P"Z<+5>05<@3:.9B;"W([EMAIL PROTECTED]
M(K."%XGP%3!.+"T3B4R(6:)6P+UU:> 2_T"A&KY5Q6M%3+;.:JMI$)AES<_G
MS\G'Q)2>)>S/Y;AZ[8W-G?%.22L9>?P3K(69]J>DW#RH[>:AZN6QRUWMJL?5
MM>%O-7?]T1),^<,;6YXNJG^Q<:XIZM"'R_Q?3#7Y=XTF]O]
MQM<:E:Y42UVJ5+A8([EMAIL PROTECTED],&L,_1B8&0D#Q)PNK"(,(@PZ([EMAIL PROTECTED]
M<.:\C%7KUG#*-EP4M>WI++QM5&5F$
ME\Y;KFYBRN(1%K%L$Y_J*J;Z0[MTW#RL^"R:_4]=UA8PNG)[EMAIL PROTECTED]
M&:P!4$L#!!0(`# #""[EMAIL PROTECTED](``#L&```39F]R;69I;&PO9FEL
M;&EN+G!H<-54;6_3,!#^O$K]#X*F`4=8VWBN^X) D(L(18D(D?."1A'+
M9EI;R;[EMAIL PROTECTED]'.A-7TWOOW2KN3V5TT=BRW-
M.8 [EMAIL PROTECTED](7><[4-&:,[EMAIL PROTECTED]<
M1E> H+I8U]8FXD%+S%7$9,&IN9*JN^\>D)S
M[$"EZORA.G' *V,:5C#=MGN_"[EMAIL PROTECTED]<9EC?PD.<2+7O_IOJU
MUQ35V-%PT#-6>J+Z"VI1135]OWE:<_9WJOX+AM:'W!)3O^G1FI%]-O1";#O2
M8]FQ>V7#JSIHS[30JJM6??P74$L#!!0(`#."[EMAIL PROTECTED]
M9F]R;69I;&PO9FEL;&EN9G)A;64N<&AP;5#!3L) $+V;^ _C'[EMAIL PROTECTED]""
MVM;[EMAIL PROTECTED]@6"-\5C:A6[2[M;=T8)?;[M+/7F:>>]-WIN9X&*VBI./]1R>DI<%
MK-\>%L\Q, _Q?10CSI*9$\;^8 B/.JVXX80X7S)@[EMAIL PROTECTED],?*7WF&RP
MH*H>4L^C\+.AH6WF:=Y4$E3QZY27/*$"'6KKBE$+GZ_'/+_$=LEA)
MXI*\Y%AS!IE#(2-^(!MU!UF1ZC8I%$9YT^GDQAO:0#PEM6V_#&C5F)!=3ZXN
M&5ARJW3.=]6I4(Z.WM/?T4'I'(H"K8J
M/[HKT;8!_FGV">[MOU!+`P04" [EMAIL PROTECTED],[EMAIL PROTECTED]@```&9O
M'&<*.U.,AYIK)I7P`3#7P4:K
MU6T:+?E0*3XJ45C9^L ,--@)W^H^YPEG:-T)FL(W7:,ZP0ITJW X&[EMAIL PROTECTED]
MD*OID;R3NB^]*(#4JJ.8K.O6!/7;.0Q"_N*; C^,S?O<8#>,S
M3=0TPY]02P,$% [EMAIL PROTECTED],(+^:[EMAIL PROTECTED]@[EMAIL PROTECTED];W)M9FEL;"]F
M;8P;D4"N)_QVZR$5 KP6A>[/O>#]_'L6[T=+:<1A]7<[EMAIL PROTECTED]:Y@
M]?[BZNT46)_S#\^GG,^B6>UX$9P-(+)"EY*DT4)Q/G_'QJ3Q1PNEE&T7(QXK3FGDOH.+*J0E;156&:(Q("V!8:,\"OQN"P99!;3
M)[EMAIL PROTECTED],D01D1$4?/U=R$[*IT82:^I%+9A#75E/%]S2$.!.V1 IE:?KGYR]?
M]0>[2KSIU&W7)MF"PI1R86^E#MDSUXPI6E:]_2(3REIVAO(V([EMAIL PROTECTED]
MN+/8IQ)5RD#$_II"YC*0,I.$;+6\B1AHD3O491$[+SI4EP_^&\6N>[2[MJ#Y
M1E(7%34IUTC6Q)[EMAIL PROTECTED];^O=45DM+/\Y?X>L!&J^D-:&^O6D)TQ`*.G2L9W(2N$
M=<<&J75'E$$NI+[TVR Q<97O/ YM$-0P05VU4UC<=(9_F5I6ZUQ2MS=DXP-@
M"Y/(5,;"];@[EMAIL PROTECTED]>6^YO:(8',E\':P;,@^&0C]+<::S]X.^ >_$$[
MWD/5;A0<\7_>""[EMAIL PROTECTED]@M0,:K$8Z'I.;?8]D.CUYXH#XPYP9<1]4ST'N!V$]
M&^MI_A-02P,$% [EMAIL PROTECTED](+Y+HJ#>)##"P$``!D```!F;W)M9FEL;"]F
M1 @M1*M,W!"/7H
MAD6V, [$"R)_W[S4T\S.[HQFD^?B.U<_Y0;>U><6RMUZ^Y&#D(C[18Y8J&)<
M+.&S&Y#TH4>V["A+<,1.<-:?H"&7BL"MHV"(
M6 "W%TH%TX.Q"D& :>@X7>B348YHNDZ\W>4Y'7GLFS5)U90#5.4TK?
[EMAIL PROTECTED],*I74=_ZT,[2/]D^N /4$L#!!0(`#2"^2X@
[EMAIL PROTECTED]"H!```79F]R;69I;&PO9G)A;65R:6=H="YH=&TM3TU/PS ,
MO2/Q'TSNG3T&]N]/FW4.(D'\N,T1"UF,PMUD.@/9*><-F]8IBUB^BL7U5:JYL9=)
[EMAIL PROTECTED]:/!^6VQ(.ZY>53'&D!LT:]PT=V4QX[BUY3<0"N#]1)IC^&"OO!>B.
MOJ)C$HB0;(@5:.930C]G\YN)O'5,CA,YA 54XQ9;PDF/4&G5>>+,^#:9S^\?
MDMFE">.A`_QLZWY R_Y<[EMAIL PROTECTED];%%..#_U!+`P04" `U#0,9U('```]& ``%0```&9OZ.G%SD:B9C!//M,U.,XF;=XB$),04P [EMAIL PROTECTED]'[#_T' `D
MH0LM>=-99A(1!^=^PR$R7IAE-CDY'B\83?'7<).QR?6'U_]^2VY^>S_N.P#L
M9%S<$L6R.-+F+F-ZP9B)B+G+61P9]M7T$ZTCLE!LYC%Z"$#*)3.4+(S)N^R/
[EMAIL PROTECTED]@!Q1!*W\EQ0H1%)%E1I9F*N9??%B\N7W:'E]/'JP\_O;TA&
MQ;R@ZCE:]/F9^1)3%KPY_1T![S7`.^V2H;[EMAIL PROTECTED]&%"&#\*1%':'>H%(G1
MG-)*^]",*=,&KR_SC!E&C$RE)AG\3:F1ND-RL'M&5U+UHE*28J90`J"99A;T
MS0D"">D*I*.D?.$BE5]ZJ4R*)11Q[UJJ99%1Q67OS:?>
M#,"Z?1BN9AE+3/NA!-P9TG\RK!C5!%.[#BOH-Y<0V:3N!G4^NLTQN2![W9 NEA26 _P'5R#C?+"[=CFSN.PJW>'V-C)!/[EMAIL PROTECTED]@9V9^-9DS^A:P=
M&BJ.1< FM2RD_DN&P] 6 XWCH&7H3;UNE_VN4
MP3K*H$()+$E7'/:&PRY0A-@(+WM5F!FX^P2W>T:^DU^8NJ*:M<]VI?C;=P3R
MCH -7"12*.7.:H!Z'.=P/$^0H;&H_!TT-
M"74-N'>+ 
MNA\>$$7?"TO^[K<>LK8GUJJMU3.K)6J>6MWVKKEUUTZO<2><7;='UPV*T9I5
MX=A:'JZAUN&)\+CS%5O1__-\_8X65!_'[EMAIL PROTECTED]/QC :! U1"D:-NQ$
M%XTD3QMWGC4QNVPD^:EQYWD3LQ>-)"^;2&X;27Z-RBR]+Y.U/[EMAIL PROTECTED]<,W.[S
M)Y5$2&*/,)U+D3)"<0#&C-J<>!^94H]-JD>GU8[$\L/RM[IO< %#O $[=K6.
M:C[K?+8Y.(G=.-3Y''2/@$'[EMAIL PROTECTED]&LK/[EMAIL PROTECTED])R^96\=J<(;?8G43@
MV#G8L&$(NE^ UF-KBRV>6OVP@"QY3)YN9<8.B;U6Y6/@A0?(028$G^M.V6$8
ME7 B?$#X'JY6G8IG.;X]&.4T[+)AM"_6HGV$;DHWRPD'@5OLJ4='3:D`Y88N
M0NON'\+;Y#W:C/ON\LI>5(W[_KX-7I]TN^.I3._(=)Y(:$EQ],.U?2*2L9E9
M0CYS8;N\D7FP&H6P7K!^'QA+$"*=Y*F<11-NETG"BBOZG^\ CJ*)Q#IV8
MST$FRHHF;J)DV'!?D3$7.7P*UJQ*R3AK$LW_A->AM?BK2V:[G(RG$T*ZX_YT
M4M8)/HW,WGPJ>5VLLT+/72VHF+-X?1#\QZ;UX9EWPZF8ZGSD_AU3[ZP?K (9
M3V[C:"&-#1HTAFV&>[EMAIL PROTECTED]%0:LZ>/"*TX(F
MA6&C)5.2E N+^0?4,D_!$_9."LYI?YU)-*MP?)R663A-CTB:WU$$Y:#
M';TYGT7$5^R+_X_#?X&4$L#! H``$^V#2\`
M```.9F]R;69I;&PO:&5L<"]02P,$"@``3[8-+P``
M`!4```!F;W)M9FEL;"]H96QP+V-O;75N82]02P,$% [EMAIL PROTECTED];;Y+NWITRFL
[EMAIL PROTECTED]@4``!\```!F;W)M9FEL;"]H96QP+V-O;75N82]F:6QL:6XN<&APM51M
M;],P$/Z\2OL/AU?6%*UO2$B#)JU&UPTD6*4R(2&$*B>Y-)Z<.+.=EL+VW['C
MK-E \ U+B7WV<^=[_)SM3P];[3A,(8!LIV[Y*A)

[PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

2003-08-19 Thread Gerard Samuel

For the most part, I got my code running with IBM DB2 8.1.3
But its slower than dirt.  Maybe 1 out of 10 times, a page would exceed 
the 30 second time limit.
I understand on a fresh database startup, it takes time to get things 
together to run.
But sometimes it would seem like its going fast, then othertimes, crawl 
slower than snails.
Im just checking with the crowd that uses DB2 via PHP to see if they get 
similar
behaviour with DB2.

Thanks.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Queries probably timing out

2003-08-19 Thread Dillon, John

I set set_time_limit (10*60); high up.

Error message:
"Lost connection to MySQL server during query"

Query is:
$query="CREATE TABLE IF NOT EXISTS $tbl1
SELECT TestData1.Year,
TestData1.Period,TestData1.Co,TestData1.Acct,TestData1.Dept,TestData1.Descri
ption,TestData1.Net,TestData1.Net*.175 AS Exps175, TestData2.USD FROM
TestData1 INNER JOIN TestData2 ON
CONCAT(TestData1.Journal,TestData1.Description)=CONCAT(TestData2.journal,Tes
tData2.description) WHERE TestData1.Dept<>'D1'";

Thanks,
John

-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: 19 August 2003 18:00
To: PHP-DB List
Subject: Re: [PHP-DB] Queries probably timing out



What leads you to believe that it's a query timeout? Is the php script
timing 
out waiting for the database? Do you get an error saying something about
"Max 
Execution Time"?

If so, you may want to set that higher in your script. Go check out: 
http://si.php.net/manual/en/function.set-time-limit.php

That's not a small database, but it unless you're query has some CRAZY join 
action in it, it should pre fairly speedy.  I've never seen MySQL time out 
though.  Even with some stupidly slow queries I've done in the past. So I'm 
guessing it's PHP.

If you get an error, post it on the list.
-Micah


On Tuesday 19 August 2003 2:59 am, Ignatius Reilly wrote:
> 
> - Original Message -
> From: "Dillon, John" <[EMAIL PROTECTED]>
> To: "PHP-DB List" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 19, 2003 11:47 AM
> Subject: [PHP-DB] Queries probably timing out
>
>
> I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows
> in another..  I think the queries are failing due to timeout on the
server.
> The server is not dedicated to me and I may not be able to affect the
> timeout settings...though I'll ask my hosting company (Positive Internet).
> If I decide to do the queries on my local PC (I don't need or want to do
> them over the internet),
>
> (1) do I have to set up my PC as a server,
>
> Yes.
>
> (2) if so what's the quickest and easiest server to get started with,
>
> Install Apache, PHP and MySQL. There are countless tutes on the web on how
> to do so. It is a breeze under Windows 2000
>
> (3) are there complications running the server on the same PC as the
client
> applications (ie my PHP code),
>
> No, except maybe performance
>
> (4) do I then download MySQL and PHP onto it, though I read PHP comes
> bundled with MySQL,
>
> PHP has an API to MySQL, but you have to have first a MySQL server running
>
> (5) will it become clear to me what host name/IP address to use to connect
> to the database (up to now I've been told by the hosting company).
>
> You can use a dynamic DNS set-up (look for instance www.dnsmadeeasy.com)
if
> you need a name-based address. Also a breeze to set up.
>
> Any other suggestions on timeouts on queries?
>
> Thanks,
>
> John
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> http://www.cantor.com
> CONFIDENTIAL: This e-mail, including its contents and attachments, if any,
> are confidential. If you are not the named recipient please notify the
> sender and immediately delete it. You may not disseminate, distribute, or
> forward this e-mail message or disclose its contents to anybody else.
> Copyright and any other intellectual property rights in its contents are
> the sole property of Cantor Fitzgerald.
>  E-mail transmission cannot be guaranteed to be secure or error-free.
> The sender therefore does not accept liability for any errors or omissions
> in the contents of this message which arise as a result of e-mail
> transmission.  If verification is required please request a hard-copy
> version.
>  Although we routinely screen for viruses, addressees should check
this
> e-mail and any attachments for viruses. We make no representation or
> warranty as to the absence of viruses in this e-mail or any attachments.
> Please note that to ensure regulatory compliance and for the protection of
> our customers and business, we may monitor and read e-mails sent to and
> from our server(s).
>
> For further important information, please read the  Important Legal
> Information and Legal Statement at
> http://www.cantor.com/legal_information.html
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Returning Results

2003-08-19 Thread Hutchins, Richard

Thanks for the response, Aaron. But my problem isn't finding out who the
referrer was. My problem is how to get the results of the database query
back to the referrer without using any html. I think I need to get it into
the request somehow.

I'm probably making things wy more difficult than they NEED to be for
myself, but my goal is to have the application logic, in this case the query
script, totally separate from the presentation layer (the html).

You know, ideally, I'd like to do something like the following pseudocode:

while($row = mysql_fetch_array($results)){
$_POST['id'] = $row['id'];
$_POST['firstname'] = $row['firstname'];
$_POST['lastname'] = $row['lastname'];
}
header("Location:http://www.mysite.org/searchform.php";);

And that would set the $_POST variables in the request without having any
HTML. I guess I should probably just try it seeing as I've already typed it
out, but I've never stumbled across anything like this before and wanted to
see if there was already a tried and true method for accomplishing it.

Ugh. I feel the headache coming on.

> -Original Message-
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 19, 2003 2:00 PM
> To: 'Hutchins, Richard'; 'PHP-DB'
> Subject: RE: [PHP-DB] Returning Results
> 
> 
> Hi Richard,
> 
> When you submit the form, why not have a hidden field in the 
> form like:
> 
> 
> 
> Then use that 'backtopage' variable in your script where you 
> direct the
> results to.
> 
> Or.. if you don't want to use a hidden field.. parse the URL 
> to get the
> referrer?
> 
> HTH
> 
> Aaron
> 
> > -Original Message-
> > From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> > Sent: August 19, 2003 1:54 PM
> > To: PHP-DB
> > Subject: [PHP-DB] Returning Results
> > 
> > OK, I'll apologize in advance if this is a little off topic, but I
> think
> > it'll be close enough.
> > 
> > I have a form (searchform.php) that collects data for a 
> search (e.g.,
> > firstname, lastname). That form submits to a separate PHP script
> > (search.php) that queries a database to find matching rows 
> and returns
> the
> > information in an array ($results).
> > 
> > All pretty standard stuff and it all works.
> > 
> > I know I "while()" the information in the resulting array ($results)
> to
> > draw
> > a table showing all of the results. But what that would 
> require is the
> > form
> > (searchform.php) to collect the data and submit to the search.php
> script
> > where HTML and PHP code combine in one file to perform the query and
> draw
> > the results. I know how to do this and have done it in the past.
> > 
> > However, this instance has a wrinkle to it. When the searchform.php
> form
> > submits to search.php, I want to perform the query, but return the
> user
> > (and
> > the $results array) to searchform.php to display the results.
> > 
> > I want to stress that I can get the information from the 
> database with
> no
> > problem. I'm just stuck on how to get the results back to the page
> that
> > called the search.php script in the first place.
> > 
> > Is turning search.php into a function and "return"-ing the 
> results the
> > only
> > way to accomplish this? Because the only other idea I can 
> come up with
> is
> > using a header("Location:http://searchform.php?rs=$results";);
> statement
> > and
> > that doesn't seem to work (and logically, I can see why).
> > 
> > I'm not asking for a total solution here because I can handle the
> whole
> > solution myself. However I would appreciate a bump in the right
> direction
> > in
> > regards to how to architect the application logic.
> > 
> > Thanks in advance,
> > Rich
> > 
> > Rich Hutchins
> > 
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Problems with input and modify data on a form.

2003-08-19 Thread José Luis Palacios Vergara

I have  a problem with some programs, I am using 4 frames, 3 of them are for
input data, the top frame is using for input information (right now only
alow show existing information), in the middle frame appear information and
with the bottom frame it's possible navigate through the records, I would
like know if somebody can test and see how can I re use the same code for
input new information. I have this using mysql database and php programming
also when you need locate some record you can push the ? and there will
appear a box with the data and that can be order by one field or another and
choose it that will appear on the top frame; if  someone find the programs
useful please feel free of use it and also if someone can help me with the
problem. In the next thread I am sending the program.

Thanks

JOSE LUIS PALACIOS VERGARA




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Returning Results

2003-08-19 Thread Aaron Wolski

Hi Richard,

When you submit the form, why not have a hidden field in the form like:



Then use that 'backtopage' variable in your script where you direct the
results to.

Or.. if you don't want to use a hidden field.. parse the URL to get the
referrer?

HTH

Aaron

> -Original Message-
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> Sent: August 19, 2003 1:54 PM
> To: PHP-DB
> Subject: [PHP-DB] Returning Results
> 
> OK, I'll apologize in advance if this is a little off topic, but I
think
> it'll be close enough.
> 
> I have a form (searchform.php) that collects data for a search (e.g.,
> firstname, lastname). That form submits to a separate PHP script
> (search.php) that queries a database to find matching rows and returns
the
> information in an array ($results).
> 
> All pretty standard stuff and it all works.
> 
> I know I "while()" the information in the resulting array ($results)
to
> draw
> a table showing all of the results. But what that would require is the
> form
> (searchform.php) to collect the data and submit to the search.php
script
> where HTML and PHP code combine in one file to perform the query and
draw
> the results. I know how to do this and have done it in the past.
> 
> However, this instance has a wrinkle to it. When the searchform.php
form
> submits to search.php, I want to perform the query, but return the
user
> (and
> the $results array) to searchform.php to display the results.
> 
> I want to stress that I can get the information from the database with
no
> problem. I'm just stuck on how to get the results back to the page
that
> called the search.php script in the first place.
> 
> Is turning search.php into a function and "return"-ing the results the
> only
> way to accomplish this? Because the only other idea I can come up with
is
> using a header("Location:http://searchform.php?rs=$results";);
statement
> and
> that doesn't seem to work (and logically, I can see why).
> 
> I'm not asking for a total solution here because I can handle the
whole
> solution myself. However I would appreciate a bump in the right
direction
> in
> regards to how to architect the application logic.
> 
> Thanks in advance,
> Rich
> 
> Rich Hutchins
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Returning Results

2003-08-19 Thread Hutchins, Richard

OK, I'll apologize in advance if this is a little off topic, but I think
it'll be close enough.

I have a form (searchform.php) that collects data for a search (e.g.,
firstname, lastname). That form submits to a separate PHP script
(search.php) that queries a database to find matching rows and returns the
information in an array ($results).

All pretty standard stuff and it all works.

I know I "while()" the information in the resulting array ($results) to draw
a table showing all of the results. But what that would require is the form
(searchform.php) to collect the data and submit to the search.php script
where HTML and PHP code combine in one file to perform the query and draw
the results. I know how to do this and have done it in the past.

However, this instance has a wrinkle to it. When the searchform.php form
submits to search.php, I want to perform the query, but return the user (and
the $results array) to searchform.php to display the results.

I want to stress that I can get the information from the database with no
problem. I'm just stuck on how to get the results back to the page that
called the search.php script in the first place.

Is turning search.php into a function and "return"-ing the results the only
way to accomplish this? Because the only other idea I can come up with is
using a header("Location:http://searchform.php?rs=$results";); statement and
that doesn't seem to work (and logically, I can see why).

I'm not asking for a total solution here because I can handle the whole
solution myself. However I would appreciate a bump in the right direction in
regards to how to architect the application logic.

Thanks in advance,
Rich

Rich Hutchins

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Calculating daylight savings time

2003-08-19 Thread Micah Stevens

Here's the example code I was talking about in the docs, you should really 
read the user submitted notes in the docs, they're very helpful, moreso than 
the docs from time to time. 

(this is not my code..)

leafrink at hotmail dot com
 28-Feb-2003 07:26



Wrote this function after a fair bit of searching on the subject.
Don't know if it's the best way to do it, but it works.

Its not that exact but it's pretty close.

Hope it helps someone out there.

/**
* function for working out if it is daylight savings for a specific date.
* must specify when daylight savings starts and ends in the format
* "[1=First,2=Second,3=Third,4=Fourth,L=Last]:NameOfDay:Of The Month"
* e.g. "L:Sun:3" = Last Sunday in March
* some will not meet this criteria but most do.
*
* see - http://webexhibits.org/daylightsaving/g.html for daylight savings 
times around the world.
* 
*/
function is_daylight_savings($gmtime,$DSTStart = '',$DSTEnd = ''){
  //global $locale;
  //For Most Of Australia
  //DayLightSavings Starts Last sunday in October
  $DSTStart = "L:Sun:10";//$locale['DSTStart'];
  //DayLightSavings Ends Last Sunday in March
  $DSTEnd = "L:Sun:3";//$locale['DSTEnd'];
  
  $DSTStart = split(":",$DSTStart);
  $DSTEnd = split(":",$DSTEnd);
  
  $gmtMonth = date("n",$gmtime);
  // if not even in the Important changeover months.
  if ($gmtMonth < $DSTStart[2] && $gmtMonth > $DSTEnd[2]){
   return false;
  } else if ($gmtMonth > $DSTStart[2] || $gmtMonth < $DSTEnd[2]) {
   return true;
 } else {
   //it is in the Start or End Month
   if ($gmtMonth == $DSTStart[2]){
  $True = true;
  $week = $DSTStart[0];
 $ImportantDay = $DSTStart[1];
   } else {//it is in the End Month
  $True = false;
  $week = $DSTEnd[0];
 $ImportantDay = $DSTEnd[1];
   }
//get the day of the month
  $gmtDay = date("j",$gmtime);
//work out what week it starts/ends.
if ($week == 'L'){
  $week = 4;
  $ldom = 4;//last day of month factor
}
//if the week in which it starts/ends has not been reached
if($gmtDay < ($week-1)*7){
return (!$True);
} else {
  $gmtDate = getdate($gmtime);
  //go by a Day of the Week Basis
  for ($i=($week-1)*7;$i<(($week*7)+$ldom);$i++){
$checkDate = mktime(0,0,0,$gmtDate["mon"],$i,$gmtDate["year"]);
   //get the actual day it starts/ends
if (date("D",$checkDate) == "Sun" && date("n",$checkDate) == $gmtMonth 
){
  $day = date("j",$checkDate);
}
  }
  if ($gmtDay < $day) {//if it has not reached the day
return (!$True);
  } else {
return $True;
  }
   }
 }
}

//Testing
if(is_daylight_savings(strtotime("26-Oct-2003"))){
 echo "is DAYLIGHT SAVINGS";
}else {
 echo "is NOT DAYLIGHT SAVINGS";
}



On Tuesday 19 August 2003 2:37 am, Lisi wrote:
> What I need to do is figure this out for more than one location at a time.
> I am displaying Sabbath times for several different cities around the world
> at once (New York, London, Paris, Jerusalem, Sydney) - i.e. a certain
> amount of time before sunset, different for each city and each city is in a
> different dst zone.
>
> Can I do something using setlocale, to change timezones to the city I need,
> and then use date(I)? Or does date(I) always work only for the US? And what
> exactly does setlocale change? I couldn't figure out from the notes on
> php.net.
>
> Thanks for your help,
>
> -Lisi
>
> At 12:06 AM 8/17/03 -0700, Micah Stevens wrote:
> >As an afterthought, the docs are inspecific on who's daylight savings
> >schedule
> >that the function returns. There's another user submitted function in the
> >comments list that takes into account a specific schedule.
> >
> >-Micah
> >
> >On Sunday 17 August 2003 12:43 am, Lisi wrote:
> > > I have sunset times stored in a database and the a PHP page that
> > > performs a number of calculations on the retrieved time. One of the
> > > things I need to figure out is whether or not to add an hour for
> > > Daylight Savings Time. Since there is more than once location, and each
> > > one begins and ends DST at a different time, I need to figure this out
> > > based on location. My question is, how do I figure out whether it's the
> > > "first  sunday in April" yet or not? I know it has to do with the
> > > date() function somehow, I'm just not sure how to use it properly in
> > > this case - any suggestions?
> > >
> > > Thanks,
> > >
> > > -Lisi


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Queries probably timing out

2003-08-19 Thread Micah Stevens


What leads you to believe that it's a query timeout? Is the php script timing 
out waiting for the database? Do you get an error saying something about "Max 
Execution Time"?

If so, you may want to set that higher in your script. Go check out: 
http://si.php.net/manual/en/function.set-time-limit.php

That's not a small database, but it unless you're query has some CRAZY join 
action in it, it should pre fairly speedy.  I've never seen MySQL time out 
though.  Even with some stupidly slow queries I've done in the past. So I'm 
guessing it's PHP.

If you get an error, post it on the list.
-Micah


On Tuesday 19 August 2003 2:59 am, Ignatius Reilly wrote:
> 
> - Original Message -
> From: "Dillon, John" <[EMAIL PROTECTED]>
> To: "PHP-DB List" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 19, 2003 11:47 AM
> Subject: [PHP-DB] Queries probably timing out
>
>
> I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows
> in another..  I think the queries are failing due to timeout on the server.
> The server is not dedicated to me and I may not be able to affect the
> timeout settings...though I'll ask my hosting company (Positive Internet).
> If I decide to do the queries on my local PC (I don't need or want to do
> them over the internet),
>
> (1) do I have to set up my PC as a server,
>
> Yes.
>
> (2) if so what's the quickest and easiest server to get started with,
>
> Install Apache, PHP and MySQL. There are countless tutes on the web on how
> to do so. It is a breeze under Windows 2000
>
> (3) are there complications running the server on the same PC as the client
> applications (ie my PHP code),
>
> No, except maybe performance
>
> (4) do I then download MySQL and PHP onto it, though I read PHP comes
> bundled with MySQL,
>
> PHP has an API to MySQL, but you have to have first a MySQL server running
>
> (5) will it become clear to me what host name/IP address to use to connect
> to the database (up to now I've been told by the hosting company).
>
> You can use a dynamic DNS set-up (look for instance www.dnsmadeeasy.com) if
> you need a name-based address. Also a breeze to set up.
>
> Any other suggestions on timeouts on queries?
>
> Thanks,
>
> John
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> http://www.cantor.com
> CONFIDENTIAL: This e-mail, including its contents and attachments, if any,
> are confidential. If you are not the named recipient please notify the
> sender and immediately delete it. You may not disseminate, distribute, or
> forward this e-mail message or disclose its contents to anybody else.
> Copyright and any other intellectual property rights in its contents are
> the sole property of Cantor Fitzgerald.
>  E-mail transmission cannot be guaranteed to be secure or error-free.
> The sender therefore does not accept liability for any errors or omissions
> in the contents of this message which arise as a result of e-mail
> transmission.  If verification is required please request a hard-copy
> version.
>  Although we routinely screen for viruses, addressees should check this
> e-mail and any attachments for viruses. We make no representation or
> warranty as to the absence of viruses in this e-mail or any attachments.
> Please note that to ensure regulatory compliance and for the protection of
> our customers and business, we may monitor and read e-mails sent to and
> from our server(s).
>
> For further important information, please read the  Important Legal
> Information and Legal Statement at
> http://www.cantor.com/legal_information.html
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mcrosoft SQL Server and "for xml auto" queries

2003-08-19 Thread Robert Twitty

The win32 version of the mssql extension does not support the FOR
XML clause because it sends the results using ntext, which is the new
UNICODE text type introduced in SQL Server 7.0.

The mssql extension was built with DB-Library, which cannot read ntext
fields.  DB-Library is obsolete, and Microsoft has no desire to enhance or
fix it.

-- bob

On Mon, 18 Aug 2003, Daniel Cher wrote:

> I've been trying for months to figure out how to get "for xml auto" queries
> to work from PHP. I've got it working from ASP, which I strongly disprefer
> (hate!).
>
> I'd simply like to do:
>
> $sql = "select * from customers for xml auto";
> $xml = $mssql->execute($sql);
> echo $xml
>
> This should return:
>
> 
>
>
> 
>
> Any help appreciated.
>
> Daniel
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problems compiling with-informix

2003-08-19 Thread Paul Gardiner

I run Informix (SE7.25.UC4 - UC5 had a major bug) on RH8.0. It wouldn't run
on RH9.0 because of the glibc 2.3.x conflict. I beleive Informix only
supports glibc 2.2.x. at the moment.

If it's possible, use RH8.0 as I know it works.

- Paul -

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 3:54 PM
Subject: [PHP-DB] problems compiling with-informix


> hi, my name is matts.
> when trying to compile php (as cgi or module) i get the following:
>
> ./configure --with-informix=/opt/informix
>
> *
>
> make
>
> *
>
> ext/mysql/libmysql/my_tempnam.o(.text+0x40): In function `my_tempnam':
> /usr/src/php-4.3.2/ext/mysql/libmysql/my_tempnam.c:115: the use of
`tempnam' is
> dangerous, better use `mkstemp'
> /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_b'
> /opt/informix/lib/esql/libifgls.so: undefined reference to
`__ctype_toupper'
> /opt/informix/lib/esql/libifgls.so: undefined reference to
`__ctype_tolower'
> collect2: ld returned 1 exit status
> make: *** [sapi/cgi/php] Error 1
>
>
> i know that my_tempnam warnings are not important, but i cant figure out
what is
> wrong with my libifgls.so
>
> I'm working in a Red Hat 9.
> I compiled php without informix support succefully several times.
> I have installed the Informix Client SDK 2.81
> (I believe)  I have all the environment variables ok (INFORMIXDIR,
> INFORMIXSERVER... ETC)
>
> I would apreciate any help 
> thanks in advance.
>
>
>
>
> -
> This mail sent through IMP: http://mail.info.unlp.edu.ar/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Queries probably timing out

2003-08-19 Thread Ignatius Reilly

- Original Message -
From: "Dillon, John" <[EMAIL PROTECTED]>
To: "PHP-DB List" <[EMAIL PROTECTED]>
Sent: Tuesday, August 19, 2003 11:47 AM
Subject: [PHP-DB] Queries probably timing out

I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows in
another..  I think the queries are failing due to timeout on the server.
The server is not dedicated to me and I may not be able to affect the
timeout settings...though I'll ask my hosting company (Positive Internet).
If I decide to do the queries on my local PC (I don't need or want to do
them over the internet),

(1) do I have to set up my PC as a server,

Yes.

(2) if so what's the quickest and easiest server to get started with,

Install Apache, PHP and MySQL. There are countless tutes on the web on how
to do so. It is a breeze under Windows 2000

(3) are there complications running the server on the same PC as the client
applications (ie my PHP code),

No, except maybe performance

(4) do I then download MySQL and PHP onto it, though I read PHP comes
bundled with MySQL,

PHP has an API to MySQL, but you have to have first a MySQL server running

(5) will it become clear to me what host name/IP address to use to connect
to the database (up to now I've been told by the hosting company).

You can use a dynamic DNS set-up (look for instance www.dnsmadeeasy.com) if
you need a name-based address. Also a breeze to set up.

Any other suggestions on timeouts on queries?

Thanks,

John

http://www.cantor.com
CONFIDENTIAL: This e-mail, including its contents and attachments, if any,
are confidential. If you are not the named recipient please notify the
sender and immediately delete it. You may not disseminate, distribute, or
forward this e-mail message or disclose its contents to anybody else.
Copyright and any other intellectual property rights in its contents are the
sole property of Cantor Fitzgerald.
 E-mail transmission cannot be guaranteed to be secure or error-free.
The sender therefore does not accept liability for any errors or omissions
in the contents of this message which arise as a result of e-mail
transmission.  If verification is required please request a hard-copy
version.
 Although we routinely screen for viruses, addressees should check this
e-mail and any attachments for viruses. We make no representation or
warranty as to the absence of viruses in this e-mail or any attachments.
Please note that to ensure regulatory compliance and for the protection of
our customers and business, we may monitor and read e-mails sent to and from
our server(s).

For further important information, please read the  Important Legal
Information and Legal Statement at
http://www.cantor.com/legal_information.html

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Queries probably timing out

2003-08-19 Thread Dillon, John

I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows in
another..  I think the queries are failing due to timeout on the server.
The server is not dedicated to me and I may not be able to affect the
timeout settings...though I'll ask my hosting company (Positive Internet).
If I decide to do the queries on my local PC (I don't need or want to do
them over the internet), 

(1) do I have to set up my PC as a server, 
(2) if so what's the quickest and easiest server to get started with, 
(3) are there complications running the server on the same PC as the client
applications (ie my PHP code), 
(4) do I then download MySQL and PHP onto it, though I read PHP comes
bundled with MySQL, 
(5) will it become clear to me what host name/IP address to use to connect
to the database (up to now I've been told by the hosting company).

Any other suggestions on timeouts on queries?

Thanks,

John






























   http://www.cantor.com
CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are 
confidential. If you are not the named recipient please notify the sender and 
immediately delete it. You may not disseminate, distribute, or forward this e-mail 
message or disclose its contents to anybody else. Copyright and any other intellectual 
property rights in its contents are the sole property of Cantor Fitzgerald.
 E-mail transmission cannot be guaranteed to be secure or error-free. The sender 
therefore does not accept liability for any errors or omissions in the contents of 
this message which arise as a result of e-mail transmission.  If verification is 
required please request a hard-copy version.
 Although we routinely screen for viruses, addressees should check this e-mail and 
any attachments for viruses. We make no representation or warranty as to the absence 
of viruses in this e-mail or any attachments. Please note that to ensure regulatory 
compliance and for the protection of our customers and business, we may monitor and 
read e-mails sent to and from our server(s). 

For further important information, please read the  Important Legal Information and 
Legal Statement at http://www.cantor.com/legal_information.html


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Calculating daylight savings time

2003-08-19 Thread Lisi

What I need to do is figure this out for more than one location at a time. 
I am displaying Sabbath times for several different cities around the world 
at once (New York, London, Paris, Jerusalem, Sydney) - i.e. a certain 
amount of time before sunset, different for each city and each city is in a 
different dst zone.

Can I do something using setlocale, to change timezones to the city I need, 
and then use date(I)? Or does date(I) always work only for the US? And what 
exactly does setlocale change? I couldn't figure out from the notes on php.net.

Thanks for your help,

-Lisi

At 12:06 AM 8/17/03 -0700, Micah Stevens wrote:

As an afterthought, the docs are inspecific on who's daylight savings 
schedule
that the function returns. There's another user submitted function in the
comments list that takes into account a specific schedule.

-Micah

On Sunday 17 August 2003 12:43 am, Lisi wrote:
> I have sunset times stored in a database and the a PHP page that performs a
> number of calculations on the retrieved time. One of the things I need to
> figure out is whether or not to add an hour for Daylight Savings Time.
> Since there is more than once location, and each one begins and ends DST at
> a different time, I need to figure this out based on location. My question
> is, how do I figure out whether it's the "first  sunday in April" yet or
> not? I know it has to do with the date() function somehow, I'm just not
> sure how to use it properly in this case - any suggestions?
>
> Thanks,
>
> -Lisi

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Query runs fine on Console but not in PHP

RE: [PHP-DB] [SPAM?] [PHP-DB] Re: That movie

Re: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

[PHP-DB] sobig virus

[PHP-DB] Re: Problems with input and modify data on a form.

[PHP-DB] Re: Problems with input and modify data on a form.

[PHP-DB] [SPAM?] [PHP-DB] Re: That movie

[PHP-DB] Re: That movie

Re: [PHP-DB] Queries probably timing out

RE: [PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

[PHP-DB] Programs

[PHP-DB] IBM DB2 & PHP 4.3.2 behaviour

RE: [PHP-DB] Queries probably timing out

RE: [PHP-DB] Returning Results

[PHP-DB] Problems with input and modify data on a form.

RE: [PHP-DB] Returning Results

[PHP-DB] Returning Results

Re: [PHP-DB] Calculating daylight savings time

Re: [PHP-DB] Queries probably timing out

Re: [PHP-DB] Mcrosoft SQL Server and "for xml auto" queries

Re: [PHP-DB] problems compiling with-informix

Re: [PHP-DB] Queries probably timing out

[PHP-DB] Queries probably timing out

Re: [PHP-DB] Calculating daylight savings time

24 matches

Site Navigation

Mail list logo

Footer information