: registry pattern!

might check http://us.php.net/manual/en/language.variables.scope.php

I have a query going to a mssql database, and ive tested the query in sql management studio… the problem is when it returns the data for some reason one of the columns won't get picked up
its weird because its the only one it happens to
cause the rest of them work fine

mssql?

http://pastebin.ca/631074
a href="http://pastebin.ca/631074"http://pastebin.ca/631074/a
yeah, im writing a program to integrate with an existing database

I had a customer trying to get the mssql extension working on their Windows VPS nothing I could do got it working.

I need to run php with tomcat web server. Is this possible?

mssql extension works fine

red9012, sure, through cgi
don't expect preformance though

mssql server shows the column with the same exact null fields as the rest of them… then why wouldnt it work
its the $tcheader['PersonalTime']

problem fixed, addslashes was applied to all $_POST variables, adding if(is_array()){ will fix,

Hi all. How do I check permissions on a file prior to running code against it? (To avoid throwing a permission denied error)

can you pastebin the source of the fopen file?

coolbeans, fileperms, fileowner and filegroup

Thanks.

can I, somehow, dump all variables available for a function?

php.net/func_get_args

pear DB is giving me hell

pear DB is so last century

shesek, been trying to use this group_concat idea you had,, but i have a few fields to deal with in this case, i can't reliably group the data for the documents with group_concat, what if it orders the data from one of the fields wrong…

ok, whats new?

but is included with php5

NET||abuse, yeah, it's not recommeneded (i don't know how to write this word..) in cases like that
what about using more than 1 query ?

PDO is a database extraction layer…not a abstraction layer :p

shesek,, so i really don't know what to do in this case.. build a big fat array with it all in there, and try to wrestle referential integrity out of an associative array?
cyth, db extraction layer?? how does that work?
what is that even?

can i have a private help discussion with anyone in here?

sounds like something to pull data out of the database

ok I figured a way to do it, I'll just pass the filename to the function

NET||abuse, an abstraction layer just basically hides the implementation of different related database mechanisms and provides it's own interface.

is there anything wrong with using php's native odbc support?

PDO isn't an abstraction layer because each database driver does have a common interface
Hmmhesays, i'd avoid if possible, but I don't see any reason not too if it's your only choice.

I should write a really awesome class to make parameterized MySQL queries easy.

cyth, I have to use PDO yet, my server only updated to supporting it last week..

acr0nym and what about, upload as different and then rename?

Octalthorpe, it's been done

cyth, but i thought that pdo abstracted the interface,, in any abstraction layer you stil have to tell it what the database is somehow..

Yeah, but is it really awesome?

NET||abuse, naw, just because how it's implemented, I don't think pdo uses the existing drivers at all.
Octalthorpe, I haven't actually used it, so I don't know
It's developed under the thumb of Zend so I don't know… it kinda depends with them.
but atleast coding standards and documentation standards are strictly adhered to

Are you talking about MySQLi?

Octalthorpe, nope
im talking about Zend_DB

Okay, just making sure.

is there a way to disable short open tag from an actual script? i have an isp who has it enabled and a xml in my first line

?

mb_convert_encoding() worked when iconv didn't when I tried to convert a CSV I got from a google program with $from_encoding = 'UTF-16LE'
don't know why, iconv kept giving me an error that it didn't recognize a certain character..

kshahnjd, you could also do an php echo 'xml ?'; ?

i use the echo method

euxneks, I think it depends on your compilation of the iconv that your using.. mb_string should always be able to convert multibyte strings however, that's what it was made for.

hrm.. well you'd expect it to work the same

euxneks, I don't expect them to, you seem to.

that's true
why should I not expect them to do the same thing?

1185107306 to something readable?

for edification

euxneks, not the same extension, built on different libraries, etc…

ok

novavision, what is it ? timestamp? if so, date

novavision, what format is that? unix timestamp?

yeah, believe so

date

looks like unix timestamp

www.php.net/date

date( 'Y-m-d', $timestamp )
^what shesek said

thanks

yeah goto page that shesek gave for more formatting options

it could be something like ddmmyyyy or something, who knows

there is a HUGE amount

I think it's seconds from epoch if I'm not mistaken

d D, M m Y y j t etc etc
you are correct

php.net/date

usually generated with time();
hah

BEWARE 32 BITS

won't the advent of 64 bit computing nullify that constraint?

euxneks, oh very much so

what's "doomsday on 2038" ?

interesting, how does that work?

I'm trying to compile php 5.2.3 and php 5.2.2, and when I get to the make test part, almost all the tests fail

shesek, when unix timestamp reaches the 32bit integer limit

ah. cool
yeah, just found it

can anyone help me with this query,, i can't figure out a way.. joining multiple fields on two tables, but table 2 has a number of entries per entry on table 1, and we are dealing with multiple fields on both tables.. how can i join/group the data to avoid more than one row per entry on table
1 and not be worries about something like group_concat() ordering different fields in different order and muddling the data.

Won't we just update the epoch?

Octalthorpe, now tell me, how would that work?

what db are you using?

mysql 5

how would you know the difference between a 2038 epoch and the 79 epoch

Easy. We'll just use one of the bits in a 64-bit integer that all systems will have in 30 years.

(or whatever year it is)
Octalthorpe, if it's 64bit it won't matter anyway

try asking in the #mysql chan
ala '/join #mysql'

won't 65 bit just make this date later?
64*

64 bit
look at the number you get with 64 bit

yeah, my stupid keyboard..

shesek, yeah, muuuuuuuuuuch later

yeah, but it will happen ?

that'll be so far into the future it's like another 100- years or something
*1000

like after we trancend the forth octave and we wil no longer have the use of computers

like in 10009 years they will ahve the same problem again?
i meant 10000 *
have*

so pdo is the way to go now huh?

damn this keyboard.

and by then we should have 128 bit computers
you would think

one hopes

hunh weird
year 584942417355 i think?
am I off or something?
oops + 1979

but they'll still have this problem..

who says it's a problem?

that far in the future I think we'll all have infinite precision quantum bits

they'll just have to upgrade to a higher bit compootar
by then everyone will have their own quantum desktop

oh. cool

:p

everyone will _be_ their own quantum desktop

well, i need to go out and get drunk

How do I call a function "statically"? I get some errors in E_STRICT mode

What's up kidos

cya you all later

have fun shesek

http://atomiku.com/scripts/ajaxchat/chat.html

Class