[prev in list] [next in list] [prev in thread] [next in thread] 

List:       twig-devel
Subject:    RE: [twig-devel] Oracle additions
From:       "Greg Ross" <greg () darkphoton ! com>
Date:       2000-11-30 18:45:20
[Download RAW message or body]


	Thanks for the diff, I've commited it and some additonal places that the
announcement code referenced the date field.

	I belive all you need to do to get quoting to work for you is to set
magic_quotes_sybase in the php config file.

								Greg

> -----Original Message-----
> From: Geoff Wilson [mailto:gmwils@netspace.net.au]
> Sent: Tuesday, November 28, 2000 10:47 PM
> To: TWIG
> Subject: [twig-devel] Oracle additions
>
>
> As I've been running TWIG against Oracle, I decided to add in an auth
> provider for Oracle. It is pretty much the same as that for the other
> databases. It has been tested and it works on my system (Solaris 2.6 /
> Oracle 8.0.4).
>
> Also, the new advanced version of announcements uses the field "date",
> which is a reserved word in Oracle. Thus should be "thedate". There
> are another couple of problems with advanced announcements, such as it
> not using MakeInsertString so SQLString is not being called on the
> entries. But I haven't fixed that yet.
>
> Also, for Oracle, the only character that needs to be escaped is the '
> quote. Unfortunately, it isn't escaped as per every other type of
> string in the known world, it has to be different. Anyway, SQLString
> should look like:
>
> Function SQLString( $string ) {
> 	return ereg_replace("'","''", $string);
> }
>
>
> For the other bits, I've included a diff. The bits missing are updates
> to the table creation scripts in setup/ to handle the switch to
> thedate for announcements. The diff is against 2.5.1.
>
>
> Geoff
>
> --
> 	a paranoid is just someone with all of the facts at his disposal
> 		- william seaward burroughs  1914-1997
>
> Geoff M. Wilson <gmwils@netspace.net.au> Work: 9811 0064 Mob: 0409 239 477
>

[prev in list] [next in list] [prev in thread] [next in thread]