Many thanks for this great advice! Definitely worth keeping and putting into
practice! Any way to write cleaner and more concise code is always worth
learning.
Best regards,
Robert
--
Robert J. Vander Hart
Electronic Resources Librarian | Lamar Soutter Library
University of Massachusetts
7;ve used other scripting languages for quite a
while.
I appreciate the replies I've received already; thanks! Sorry for not catching
my simple errors before sending out that message.
Best to all,
Robert
--
Robert J. Vander Hart
University of Massachusetts Medical School
508-856-3
| int(5) | NO | PRI | NULL| auto_increment
|
| sent_email | varchar(20) | YES | | NULL|
|
| suffix | varchar(50)| YES || NULL |
|
+-+--+--+-+-+---
On 10-12-19 12:17 AM, Ethan Rosenberg wrote:
Dear List -
Thanks to all for your EXCELLENT comments. I definitly agree that
goto is a command to be avoided at all costs.
Closed-minded drivel (or you're buttering up the popular opinion crowd).
A better approach is that goto should be used with
On 10-12-17 12:08 PM, Steve Staples wrote:
On Fri, 2010-12-17 at 10:50 -0600, Jay Blanchard wrote:
[snip]
Thank you with your excellent help in the past. Here is another
puzzler
I am trying to write a program that can have two(2) independent forms
in one PHP file. When I run the code belo
On Wed, 2008-04-30 at 11:14 +0200, Aschwin Wesselius wrote:
> Shelley wrote:
> > Hi all,
> >
> > I am currently responsible for a subscription module and need to design the
> > DB tables and write code.
> >
> > I have described my table design and queries in the post:
> > http://phparch.cn/index.p
On Thu, 2008-01-03 at 09:18 -0600, Balaji A wrote:
> Hi,
>
> I have a table with the below fields. (id, title, language, author &
> link to the book).
>
> Initially I want to display a page with 3 select boxes (language,
> author & title).
>
> Initially first select box displays the available la
You should have a line like this in your httpd.conf
PHPIniDir "C:/Program Files/Apache Group/Apache2.2/php5.2"
Make sure that is pointing to the directory where your php.ini is
located.
"Success is the ability to go from one failure to another with no loss
of enthusiasm."
Sir Winston Churchi
rtant but I'm
using persistent connections.
[EMAIL PROTECTED] wrote:
Robert wrote:
I want to store the results of a SELECT query in order to be able to
page through those results and allow the user to select one, see it
in more details and then return to the original list of results.
What&
I want to store the results of a SELECT query in order to be able to
page through those results and allow the user to select one, see it in
more details and then return to the original list of results. What's the
usual technique for doing this?
--
PHP Database Mailing List (http://www.php.net/
On Thu, 2007-10-04 at 11:56 +1000, Chris wrote:
> Robert Cummings wrote:
> > On Thu, 2007-10-04 at 11:23 +1000, Chris wrote:
> >> Robert Cummings wrote:
> >>> On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote:
> >>>> This is only from my own
On Thu, 2007-10-04 at 11:23 +1000, Chris wrote:
> Robert Cummings wrote:
> > On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote:
> >> This is only from my own personal testing. Mind you that I have only been
> >> using PostgreSQL for a
> >> year or so. Bu
On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote:
>
> This is only from my own personal testing. Mind you that I have only been
> using PostgreSQL for a
> year or so. But one problem that I have always ran into with MySQL is that
> when JOIN'ing tables
> that have large data sets is a PITA.
Stut wrote:
Robert Hicks wrote:
I have been away from PHP for a while and was wondering what is the
preferred method of accessing Oracle?
With modesty and respect, walk slowly towards it bowing your head at all
times and being careful not to relieve yourself all over the floor
I have been away from PHP for a while and was wondering what is the
preferred method of accessing Oracle?
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ion of Instantclient.)
I was able to build the module by tweaking the Makefile to link against the
Oracle 32-bit libraries, but the resultant module dumps core:
$ cat oci-test.php
$ /usr/local/php-4.4.4/bin/php -f oci-test.php
Segmentation Fault (core dumped)
Any help appreciate
On Tue, 2006-06-20 at 12:34, Juanjo Pascual wrote:
> How can i know which of both is better to use each time?
Use mysql_pconnect() if the connection overhead is large. This is
usually the case if the database is off on a remote server somewhere in
lala land. Remote servers within your LAN don't us
Attn: The President/CEO
I am Mr. Robert Maloney aged 54, Personal Assistant to PRINCE JEFRI BOLKIAH,
who was the former Finance Minister of Brunei, located in the northwest of the
island of
Borneo. Brunei Darussalam is a small country governed according to Islamic
values and traditions by His
Does anyone have an example of how to insert and select a blob field in a
MySQL 4.1 database ?
--
Thanks,
Robert L. Campbell
510 Rook Rd.,West Point, TX 78963
Office: 979-242-3083
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hane you tried
$result = mssql_query("EXEC getSomeCoolData '061451221', NULL, NULL" );
Also, did you try mssql_init()?
-- bob
On Wed, 4 Jan 2006, meska wrote:
> Hi,
>
> I've done it in various ways, still, no luck..
>
> Lets say i have a stored procedure getSomeCoolData declared as :
>
> [getS
Do you have the "truncate log on checkpoint" option enabled? Also, if you
want to reduce the size of the log file if shrinking doesn't work, try
running the following against the database. Of course, you should backup
the DB first.
SET NOCOUNT ON
DECLARE @LogicalFileName sysname,
@M
Using COMMIT is only required if you issued a BEGIN TRANS before your
INSERTs, UPDATEs and / or DELETEs. All transactions are automatically
committed if you don't use BEGIN TRANS. Are you backing up the
transaction logs regularly?
-- bob
On Fri, 16 Dec 2005, Alex Gemmell wrote:
> Hello people,
Based on my understanding of pconnect, it is a poor man's implementation
of connection pooling. Connection pooling requires a mediator server
between the client and database in order to maintain a connection for
reuse by another client. PHP does not provide such a server, so it uses
the web server
I don't think this is an issue with an old vs new ntwdblib.lib. The reason
is because I don't belieeve there is a new ntwdblib.lib. Microsoft has
not made any changes to this library since SQL Server 6.5. Therefore, the
problem lies in the PHP 4.4.0 source code for the mssql extension.
-- bob
O
and GR_PWD parameters. I have
searched all over, and don't find anything related.
Any help in this regard will be greatly appreciated.
Thanks in advance,
Robert Binneman
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Then, is it safe to assume that you can run stored procedures and queries
that don't use a remote linked server? Fundamentally, I don't know why
PHP would be the problem, since the remote link is established within the
stored procedure. To make sure that it is not a problem with the mssql
extensio
Greetings,
I have a problem which shows up *intermittently* when executing a
simple query. Basically, mysql_query() returns no resource *some* of
the time. When I trap the error using mysql_error(), I get the
following:
"No Database Selected"
For kicks, I altered the query to use the full
Assuming you always connect to the server using the exact parameter values
for odbc_connect(), this does not look like an easy one to solve. I also
connect to a Sybase database on a Win2K server from PHP/Apache/Solaris.
However, I don't use the odbc extension. I use the odbtp extension, which
work
You have 3 options.
Option 1: Use PHP's native odbc extension. This option is limited, and
only works on @in32 platforms.
Option 3: Use PHP's COM support. This option only works on @In32
platforms, and does not follow the function paradigm of PHP's database
extensions. Example code:
http://aspn.a
just giving
a millisecond to breathe or something while checking to see if the
connection is busy. But with that one line, all is well.
--
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
rror
The process just hangs with the large number of lines, I have to kill the COPY process
for postgresql on the server before trying again.
--
Robert
Try odbtp, http://odbtp.sourceforge.net.
-- bob
On Fri, 15 Oct 2004, Swapan Mazumdar wrote:
> Hi All,
>
> I am quite new to php. I have a requirement to query dbase file to
> implement searching on table columns. Now I am following a basic
> approach using dbase_get_record_with_names($fileHandle
no experience with odbtp, so can't really judge on that
> one.
>
> Anyway, thanks again Bob, input is goood.
>
> -TG
>
> > -Original Message-
> > From: Robert Twitty [mailto:[EMAIL PROTECTED]
> > Sent: Friday, October 01, 2004 2:27 PM
> > To:
There are many facters that have to be considered to make a proper
decision. First, as you have stated, mssql offers many features not
available in mysql. If these featuers are important, then you should
choose mssql. However, PHP's support for mysql is much better than its
support for mssql. PHP
ADODB is a PHP abstraction layer class. In other words it hides the fact
that it is using the odbc extension to connect to Access. And, it has
another driver that uses the COM extension to connect to Accesss
(ado_access).
Basically there are only 3 options for connecting to Access from PHP. They
a
A very good solution for connecting to an MS Access database is the odbtp
extension. You can get it at http://odbtp.sourceforge.net. It provides
support for many of Access's features, such as UNICODE text data and query
processing, and stored query execution. An example on how to connect to a
MS Ac
>> Is there anyone here can tell me how to access Matisse DB? Thank you.
>
> Isn't there anyone can help me?
Look at http://www.matisse.com/pdf/developers/php.pdf
I found it by Googling for "Matisse PHP"
-- bob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
On Thu, 16 Sep 2004, Petrus Ali Saputra wrote:
> John Holmes wrote:
>
> > Petrus Ali Saputra wrote:
> >
> >> Petrus Ali Saputra wrote:
> >>
> >>> Is there anyone here can tell me how to access Matisse DB? Thank you.
> >>
> >>
> >> Isn't there anyone can help me?
> >
> >
> > ODBC?
> >
> Yes, but it
Hi Brian
Why don't you just avoid using sybace_pconnect() with transactions?
I use ODBTP to connect to SQL Server and Sybase databases, and this is not
an issue. The reason is because ODBTP involves the use of a mediating
service that pools all connections, and automatically rollbacks
transactio
HI Bozhan
When you append the "FOR XML" clause at the end of a query, the xml data
will be sent in a single column result set. The column's type is ntext,
which is not easily handled by FreeTDS and PHP. The reason is because it
is UC2-2 encoded UNICODE text. UNICODE text is easier to deal with if
The reason is because the buffer used by the odbc extension to store field
names is only 32 bytes. You can try using the sybase or odbtp extension.
Otherwise, you will have to submit it as a bug, so that it will be fixed.
-- bob
On Thu, 9 Sep 2004, Anthony Robins wrote:
> When retrieving ODBC r
If HAVE_SQL_EXTENDED_FETCH is defined, then the odbc ext will use the
ODBC API function SQLExtendedFetch instead of SQLFetch to retrieve
records. SQLExtendedFetch is only necessary if a forward-only cursor is
not being used. In the case of the odbc ext, it uses a dynamic cursor if
HAVE_SQL_EXTENDE
On Thu, 19 Aug 2004, Gerard Samuel wrote:
> Robert Twitty wrote:
> > Hi
> >
> > Is anyone using PHP to connect to an IBM DB2 database? The reason why I
> > am asking is becaouse I want to see if the odbtp extension can be used to
> > successfully prepare and e
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So far, ODBTP
performs quite well with IBM DB2 in regards to regular queries.
-- bob
--
The odbtp extension has be used quite successfully with DB2. You can get
it at http://odbtp.sourceforge.net. I have not personnally used it with
DB2, but there are posts on odbtp's help forum pertaining to DB2.
-- bob
On Tue, 3 Aug 2004, Javier Mestre wrote:
> Any example how to use CLOB,BLOB f
Assuming your PHP script is located on a Win32 server, you will have to
run the web server under a user account that has permission to access the
remote drive. You then have to reference the MS Access database by its
UNC path.
-- bob
On Mon, 2 Aug 2004, Paul Kain wrote:
> I am aware that theres
tement to lookup
that data for validity.
--
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
n";
exit;
}
echo $copydata;
$next_id++;
break;
} // end switch
} // end while
pg_put_line($dbh, "\\.\n");
pg_end_copy($dbh);
echo "End: ".date('Y-m-d H:i:s')."\n";
pg_close($dbh);
echo "ending process...\n";
fclose($handle);
--
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
is is the first time doing anything like this, looking
for anyone with this experience to offer some guidance?
--
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi Mark
The US Holocaust Memorial Museum (Department of Interior) primarily uses
PHP for web application development. The reason is because the main web
server is Apache on Solaris. IMHO, if you are using Apache on Linux/UNIX,
then PHP is probably your best choice. If you are using IIS on Window
Hi Damien
IMHO you should use the odbtp extension to connect to SQL Server
databases, especially on a Win32 platform. The Win32 version of the mssql
ext uses DB-Library. This library is obsolete, unsupported by MS, and does
not completely support SQL Server databases beyond version 6.5. Also,
bec
The problem is caused by the fact that the sybase extension was installed
instead of the mssql extension. The sybase extension supports some of the
mssql functions via aliasing. Unfortunately, mssql_init() is not supported
by the sybase ext. You basically have only 2 options:
1. Rebuild PHP with
Last I checked the HTTP spec still doesn't know how to spell. You
should find that $_SERVER['HTTP_REFERER'] has what you want.
On Fri, 09 Jul 2004 17:49:41 GMT, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> For some reason I cannot get this to work. I'm trying to use the referrer to
> redirect at
ich ODBC connection do you prefer ?
>
> thx to help me
> Jeff
>
>
> "Robert Twitty" <[EMAIL PROTECTED]> a écrit dans le message de
> news:[EMAIL PROTECTED]
> You will have much better results if you use the odbtp extension instead
> of the odbc extenstion, especia
You will have much better results if you use the odbtp extension instead
of the odbc extenstion, especially on Linux. The odbtp_field_type()
function will give you the correct type name.
Also, you could use the mssql extension. However, mssql_field_type()
returns type names that are not exact. For
If this is the problem, then you should try the odbtp/mssql hybrid
extension, php_odbtp_mssql.dll. It is thread-safe, and is available at
http://odbtp.sourceforge.net.
-- bob
On Fri, 2 Jul 2004, Frank M. Kromann wrote:
> That depends on the SAPI you are using. With CGI or FastCGI there is no
>
hat.
>
> - Frank
>
> > Robert,
> >
> > Do you have an example of pulling the Column types from an MS Sql query?
> For example: select top 1 * from mytablename.
> >
> > loop thru the fields in the recordset and print out their data types?
--
PHP D
FYI for the members of this list that are using ODBTP:
Version 1.1.1 has been released, and is available for download at
http://odbtp.sourceforge.net
Key Changes:
* All version 1.1 known bugs have been fixed.
* Data truncation detection.
* Auto char to wide char mapping for MS Access in UNICODE
Hi
I am not aware of a website that talks about cursors. However, I do know
that they should be avoided whenever possible. They tend to require a lot
of resources. I mostly use them in stored procedures when I need to loop
through a result set. If you like, I can provide you with MS SQL Server
sy
It appears that you want to extend DB_coomon not DB. The reason is because
$dbh = MyDB::connect( $dsn );
returns an instance of the DB_common class. However, DB_common is the base
class for writing a PEAR DB driver class. And, what is really returned by
DB::connect() is an instance of the dr
Hi Alex
ADODb will not work either. ADODb is basically a PHP abstraction class
library that relies on lower level database extensions to connect to the
various databases. The problem for you is that other than the odbc
extension combined with MDBTools, and the odbtp extension, there is no
other
On Wed, 12 May 2004, Alex Gemmell wrote:
> Hello all,
>
> I am fairly new to Linux/PHP so please bear with me. I have an awfully
> awkward problem to solve - a stop gap solution for the next 6 months until
> we have out in-house servers set up and running. I also have a very short
> timeframe to
> > If you are able to place the Access database on a Windows machine that can
> > be accessed by the Linux machine, then you can use odbtp. You can get it
> > at http://odbtp.sourceforge.net.
> >
> > -- bob
>
> My problem is i can't modify my PHP code. Actually the web site runs on a
> windows200
If you are able to place the Access database on a Windows machine that can
be accessed by the Linux machine, then you can use odbtp. You can get it
at http://odbtp.sourceforge.net.
-- bob
On Wed, 5 May 2004 [EMAIL PROTECTED] wrote:
> Hi,
> I try to configure a web server under Debian/GNU/Linux
"$item_num -
$item_desc\n";
}
}
My assumption is that BOTH IF statements are not working correctly since
the logic is that if they are built the same they would react the same.
HELP!
TIA!
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
mages and
pages with a leading '/' character, and everything is working fluidly.
Now I'm ready to call it a week and go to the beach!!! Who's with me?!
BTW, if you want to see the output pages then feel free to click here:
http://www.pfssales.com/catalog.html and click on any of the l
x27;t find the right files. It's on track and working all neat
and tidy now.
Thanks for the help guys! I still feel like a doofus though...
Robert
-Original Message-
From: Richard Harb [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 11:46 AM
To: Robert Sossomon
Cc: [
ached the php file that does the site generation and maybe it will
shed some light on what I am trying to do as well.
TIA!!
Robert
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 11:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROT
_block holds all the data it accumulates through the run. How
do I rewrite the inlclude to work, or do I need to find another way to
make the includes? The includes are all template files that I used on
the site to keep everything consistent.
Thanks,
Robert
--
PHP Database Mailing List
$items[id];
$item_num = $items[item_num];
Overtime I need to rewrite my DB loading script to handle this for me,
but right now I need to band-aid it so that I can auto-generate pages
and get them loaded into a catalog.
Thanks!
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscr
'll have to change it to fit your needs, but I just have a
while loop that gets the information and then dumps each line it gets
out to a temp variable. On the pages that include this one is where the
displaying comes out.
HTH,
Robert
-Original Message-
From: andy amol [mailto:[EMAIL
Hi,
I am not sure if my issue can be partially solved by a good database
design or that all stands or falls with the application.
If I have a bunch of locations in a table and I want to describe a
route between a number of these locations, what's the best way to do
it, considering that it must b
On Wed, 14 Apr 2004, Matt Matijevich wrote:
[snip]
> [/snip]
>
> Thanks for the response.
>
> If I was hitting the memory limit, wouldn't php throw me some kind of
> error? Or would it just abort?
>
It's normally the job of the extesion to report the error. But, I am not
completely sure because
Hi Matt
Before sending the result set, the mssql extension stores the entire
result set into memory. However, PHP limits the amount of memory that
can be allocated by a script to 8MB. So, the query will fail if the
result set is larger than 8MB. You can change this value in php.ini with
the mem
ing one of the durn things..
Robert
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 4:10 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Where's the error?
I think you're right, Robert. Hopefully, your editor has a Match Bra
mile of them???
I feel like a fool..
Oh well..
Does anyone have a GOOD static page generation script that I can use to
parse this file and create the static pages that it will link to?
Thanks for the help!
Robert
-Original Message-
From: Dan Brunner [mailto:[EMAIL PROTECTED]
n the HTML code somewhere.
> -Original Message-
> From: Robert Sossomon [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 08, 2004 3:56 PM
> To: 'Edward Peloke'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Where's the error?
>
>
> It is not displaying anythi
thing?
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Where's the error?
I have this script which SHOULD produce a linked webpage for soon-to-be
created static web pages, however I can'
I have this script which SHOULD produce a linked webpage for soon-to-be
created static web pages, however I can't seem to find the error in my
code:
PFS Sales Categories Select a category to
see its items.";
//Show categories first
$get_cats = "select id_num, id_name, description, cat_code from
P
A question pertaining to this topic was posted in another forum. I have
included the answer here for those who have to deal with this issue.
Unlike MS SQL Server 7.0/2000, MS Access 2000 does not use separate types
for non-UNICODE and UNICODE text data. Instead, ALL text data is stored as
UNICODE.
OK, so I feel a complete ID10T...
Why is it always the simple things which I think about after I send out
the email that comes and bites me in the butt??
Oh well, thanks for the kick in the pants and commands!
Robert
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED
ow do I check it against a directory to see if the file exists?
Thanks,
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ly, I do not favor the SSO
> solution, but I understand the business drive for it. Security and
> convenience are often strange bedfellows, and don't always get along.
> You are correct in the IIS supports SSO.
> david
>
>
> "Robert Twitty" <[EMAIL PROTECTED]> wrot
Apache 2 and Windows, and so, long story short, perhaps I should
> consider other web server options.
>
> Thanks, Bob!
> david
>
> "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Hi David
> >
> > Do these few que
Hi David
Do these few queries ALWAYS fail, or just occasinally fail? Is this
intranet site used by many people? If the same query always fails, you
can determine if it may be a thread-safe issue by running that query
outside of Apache as follows:
c:\php\php thequery.php
If the above fails, then
acter
> fields as well.
>
> Thanks!
>
> david
>
> "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > What type of field is PhaseFK?
> >
> > -- bob
> >
> > On Wed, 17 Mar 2004, david wrote:
What type of field is PhaseFK?
-- bob
On Wed, 17 Mar 2004, david wrote:
> Hello there!
>
> I have just about driven myself crazy with an odd intermittent problem.
>
> I have an intranet site, a good size one at that, on a Windows 2000 Server,
> running Apache, connecting to another Windows 2000
You will need to install and configure the FreeTDS library. Another
alternative is to use ODBTP, which is available at
http://odbtp.sourceforge.net. It is much easier to
install and configure than FreeTDS, and supports all of the mssql_*
functions. However, ODBTP requires a WIn32 service to be in
How can I write a sort to sort on 2 columns, one ascending, one
descending?
$get_list = "select * from access_tracking where user = '$user_id' order
by time,date_accessed desc"
But the ordering seems backwards sorted by date first, and then time.
TIA!!
Robert
--
PHP D
Is the machine running SQL Server also hosted by the same company? Is it
possible to use PHP on a Win32 machine so that you can use
the php_mssql.dll extension?
-- bob
On Fri, 12 Mar 2004, S K Rana wrote:
>
> My domain is hosting through a hosting company on Linux with PHP 4.3.4.
> Hosting comp
Hi Mark
An alternative solution for connecting to MS Access is odbtp. Details are
available at http://odbtp.sourceforge.net. It provides better support for
ODBC, especially in regards to MS Access. Take a look at the
storedqry.php example at http://odbtp.sourceforge.net/examples.html. It
shows
lay_block .= "\nhttp://www.gcnorris.com/index3.html\";>Click Here to continue
through to the Garland C Norris Website. You should be receiving
an email shortly with the information you have just submitted.We
look forward to seeing you in May!";
?>
Thanks For Registering
Hi Pascal
The odbc extension uses ODBC 2, while Access and Pervasive are most likely
using ODBC 3. This may or may not be the cause of your problem. Try using
the odbtp extension at http://odbtp.sourceforge.net. It uses ODBC 3, and
may give you better results.
-- bob
On Wed, 25 Feb 2004, Pascal
he context is
changed back to the original DB. Are you changing the DB after
connecting?
-- bob
On Sun, 22 Feb 2004, Michael Flanagan wrote:
> Robert,
>
> Believe it or not, it's a simple SELECT statement! (I'm not even aware
> that I'm changing context, nor exactly
Hi John
I have never used MSDE, but from my understanding if is suppose to behave
like SQL Server. When you installed it, did it mention anything about
whether or not TCP/IP connectivity should be supported? You may need to
ensure that the server is communicating over port 1433. If you are
unsuc
0. This will only be handled
> by PHP if mssql.min_message_severity = 0.
>
> The mssql_get_last_message() function will always return the last message
> from the server. This function should not be used to check for errors. The
> function is intended to give the programmer a tool t
Hi Michael
Yes, I am the developer of ODBTP, and changing the database context will
not cause a problem.
-- bob
On Thu, 19 Feb 2004, Michael Flanagan wrote:
> Hi Robert,
>
> I've seen your name on a few of the ODBTP posts. You're one of the
> developers of same, yes?
Hi Michael
You might get better results using the odbtp extension with support for
the mssql functions. Since you are using Windows, use
php_odbtp_mssql.dll instead of php_mssql.dll.
-- bob
On Thu, 19 Feb 2004, Michael Flanagan wrote:
> Adam, Thanks for the suggestions. I don't want to ignore
Your query resource was detached from the connection. Can you supply the
code prior to calling odbtp_fetch_row() and starting from odbtp_query()?
-- bob
On Tue, 17 Feb 2004, Sascha Kaufmann wrote:
l
> Hello everyone
>
> I try to port an application from Windows/ODBC to Linux/ODBTP, I have a
> MS
t; - Paul
>
> -Original Message-
> From: Robert Twitty [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 13, 2004 12:34 PM
> To: Karen Resplendo
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Paging large recordsets
>
>
> Most of the PHP solutions I have s
1 - 100 of 274 matches
Mail list logo
