> Or is there a better way to check multiple options against an enum inside
> your select statement?
IN
for example: orderstatus IN ( 'Cancelled', 'New', 'Denied', 'Expired')
However this is not exactly what you are doing. You want different orderdate >
$yesterday depending on the orderstatu
mands on the same line. Other
than that it looks correct - what is the error?
Frank
> From: "Ethan Rosenberg, PhD"
> Subject: mysqldump
> Date: January 1, 2013 3:50:50 PM PST
> To: PHP Database List
> Reply-To: erosenb...@hygeiabiomedical.com
>
>
> Dear List
hat match
that store_by?
Good Luck,
Frank
On Aug 9, 2011, at 11:31 AM, php-db-digest-h...@lists.php.net wrote:
> From: Chris Stinemetz
> Subject: foreign key
> Date: August 9, 2011 11:31:51 AM PDT
> To: php-db@lists.php.net
>
>
> Okay. I am pretty new to mysql so this may
where concat(user, '@', host) like
(select CURRENT_USER())\G
That worked for me, I'm sure you can go join to INFORMATION_SCHEMA and
do more exotic (more precise) things too.
Good Luck,
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
platforms.
- Frank
> There's a limit of 30 characters for column names, but only if you
> connect to your mssql server from windows (more info on
> http://hu2.php.net/mssql).
>
> > The native SQL driver for PHP has a problem with a limit on the number
> > of cha
Keep calling odbc_resilt() untill everything is returned:
$str = "";
while ($tmp = odbc_result($rs, $column)) {
$str .= $tmp;
}
You can also use odbc_longreadlen() to set the number of bytes returned by
each call to odbc_result().
- Frank
> Hi,
>
> I've got a PHP
Sounds like a permission problem. Make sure the IIS user (IUSR_) has access to the share.
- Frank
> Hello,
>
> Im using PHP to connect to a Microsoft Access database which is not
stored
> on the machine where IIS is installed. It's located on a different file
> server on
Luck,
Frank
On Feb 27, 2007, at 3:58 AM, [EMAIL PROTECTED] wrote:
From: aconite <[EMAIL PROTECTED]>
Date: February 27, 2007 3:58:23 AM PST
To: php-db@lists.php.net
Subject: error creating tables
im trying to create a database in a php file.i have MySql 5.0.33
PHP 5.2.1
this is the cod
Or use the mssql.secure_connection = On in php.ini to allow the system to
use the current user account for authentication.
- Frank
> Hello,
>If you can change the SQL Server Authentication to the Mixed Mode
> (Windows and Remote User), your problem will be fixed. If you use
so I think you will be happy about
the change.
- Frank
> Hi Frank,
>
> El vie, 12-01-2007 a las 10:49 -0800, Frank M. Kromann escribió:
>
> > 1) Check the version of FreeTDS on both systems.
>
> It proved irrelevant. See above.
>
> > 2) Check the freetds.c
Hi Claudio,
1) Check the version of FreeTDS on both systems.
2) Check the freetds.conf file for differences (use the sam TDS version)
3) Check that php is compiled using --with-mssql on both systems
(--with-sybase will give you aliases to some mssql_( functions but not
all)
- Frank
> Hi
erhaps there is another account the sys admin wants to use.
Good luck,
Frank
On Oct 10, 2006, at 7:39 AM, [EMAIL PROTECTED] wrote:
From: "Daevid Vincent" <[EMAIL PROTECTED]>
Date: October 9, 2006 6:01:16 PM PDT
To:
Subject: What's the PHP equivallent of "mysql mydb
If you only have Wednesdays in you table - that is select the next 12
records after today it's easy:
SELECT * FROM christian_discipleship WHERE created_for_date > now()
ORDER BY created_for_date ASC LIMIT 12
Good luck,
Frank
On Oct 6, 2006, at 8:29 PM, [EMAIL PROTECTED] wrote:
IIRC: When you are using ISAPI you must have php,ini in the windows
directory.
If you are using CGI you can have it in the same directory as all other
PHP files.
- Frank
> Hi
>
> Make sure that the php.ini file being used is the one you thinkit is.
>
> I keep mine in the php
Try the MSDN library:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjconnectionpme.asp
- Frank
> Chris wrote:
> > Todd Cary wrote:
> >> [Sorry - I misposted this in the General group]
> >>
> >> I am in the process of conver
What about 'select count(*) from aTable'
- Frank
> Is there a way to get the number of rows that would have been returned
had
> there not been a LIMIT clause in a SELECT statement?
>
> For example, if
> Query #1) SELECT * FROM aTable
> would normally return 100 r
t it depends only on dblib from
Microsoft.
- Frank
> You still need to set the PHPRC system variable to c:\php5 (on the
> System Properties menu, Advanced tab, click Environment Variables).
> Also, PHP4 has an "extensions" directory. PHP5 should point to
>
> extension
u don't install these) and create Server
aliases.
- Frank
> mssql has a dependency on mysql. Go figure.
>
> MySQL has some dependencies, also, although they are a little easier to
> find info on and do not require installing other extensions. If you
> have the PHPRC
rolly won't get any insurance of this
risk unless you are prepared to pay a big premium - which defeats the
purpose!
Others no doubt will be able to add more control layers - these are just
what first comes to mind in a few minutes.
Bon voyage!
Frank.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
u can put on your web page) depending on how deep you want to get.
Good Luck,
Frank
On Jan 6, 2006, at 2:45 PM, [EMAIL PROTECTED] wrote:
From: "swoll2" <[EMAIL PROTECTED]>
Date: January 6, 2006 3:34:52 AM PST
To: php-db@lists.php.net
Subject: retaining and displaying line retur
for what your after.
Good Luck,
Frank
On Dec 10, 2005, at 5:02 PM, [EMAIL PROTECTED] wrote:
From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>
Date: December 10, 2005 5:04:28 PM PST
To: PHP DB
Subject: SELECT
Reply-To: [EMAIL PROTECTED]
I am trying to put together a SELECT syntax. I
stay
unchanged but REPLACE will delete the old row so all other columns
will be their default values or NULL.
Feel free to write with more questions,
Good Luck,
Frank
On Dec 7, 2005, at 9:42 PM, geekgirl1 wrote:
This is the problem. I want to add the value of $_POST[review] to the
reviews t
nnot find the page you
asked for) and have this page look at it's url, parse it and figure
out which DJ's page to show. You can also handle other pages that
may not be there (http:/mysql.com/ is like this - type anything after
that URL and it will go to that page if it finds it or it will go to
the generic search page).
You've got a lot of work in front of you, Good Luck,
Frank
n the new version of mySQL 'view' will be a reserved
word (and views will be supported). This is not causing your problem
but you do want to choose another name for your table.
Good Luck,
Frank
On Sep 19, 2005, at 11:25 AM, [EMAIL PROTECTED] wrote:
From: Yui Hiroaki <[EMAIL PRO
the select that belong to the right hand table will be
NULL where there is no row to join to).
But if you could be more specific - send the schema and precisely
what you were looking to do I could give you an example of how to
make it work.
Good Luck,
Frank
On Sep 1, 2005, at 5:00 AM, [
tension
(so far only available under php5) but the problem could be fixed there.
Just replace php_mssql.dll with php_dblib.dll. You can download a copy
from my site (http://kromann.info/php.php).
- Frank
> I've found that since PHP 4.3.4 many people had problems with MSSQL
> extension.
>
Hi Todd,
PHP has native support for MSSQL Server. On a *nix platform you need to
install and configure FreeTDS and recompile php using --with-mssql, but
then you will be able to use the mssql_* functions.
- Frank
> I have been asked by my client to use SQL Server for my php applicat
sybase_query('update tbl set col = "hello world" where key =
"therowkey"')
Cheers, Frank.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
call. This
will only be available in PHP 5 as PHP 4 is closed for new features.
- Frank
> Hello,
>
> I'm trying to build a demo of SQL Injection (SI) to discuss with my
> students. The idea is to use the live demo to show and discuss how to
> avoid SI using some secure code tech
You can have PHP generate a small javascript section where you define the
variables or you can use cookies.
- Frank
> Hi there everyone,
>
>
>
> Just a quick question, I have a login system that stores whether you
are
> logged in or not with a PHP Session. However, I need
> > Philip Wasshington wrote:
> > [snip]
> >> After installing php-4.3.9-3.6.src.rpm on RHEL4 I modified the
> >> php.spec file to
> >> add --with-sybase-ct=/opt/sybase/OCS-12_5
Try adding --with-apxs as well!
Cheers, Frank.
--
PHP Database Mailing Li
then execute $myQuery as one statement.
2 - Why `DELETE FROM purchaseItems WHERE orderID = '789' ` why not:
DELETE FROM purchaseItems WHERE orderID = '789' and itemIDs =
Good Luck,
Frank
On May 20, 2005, at 5:02 PM, [EMAIL PROTECTED] wrote:
From: "mayo" &l
newTable (column1, column2, ...)
SELECT column1, column2, ... FROM oldTable WHERE column3 < "some
date" /* or whatever */
DELETE FROM oldTable WHERE column3 < "some date" /* or whatever */
Be sure the two where clauses match exactly.
Good Luck,
Frank
On May 19, 2005, at
Hi Jim,
echo cannot display the content of an array or object. try print_r() or
var_dump()
- Frank
> Ok,
>
>
>
> I'm a PHP newbie and I'm having a problem. All I want to do is parse
> some information out of a database and send someone and email stating
&
d see the files on it's
machine but not on the others).
Personally I'd use the DB but I know SQL pretty well and I think I
would always have a DB available.
Good Luck, feel free to ask more specific questions.
Frank
On Apr 23, 2005, at 2:07 PM, [EMAIL PROTECTED] wrote:
From: Paul Reill
k exactly but look at:
<http://www.phpbuilder.com/manual/function.array-multisort.php> to
see).
I'd do it in MySQL but that's me...
Good luck,
Frank
On Apr 17, 2005, at 2:13 PM, [EMAIL PROTECTED] wrote:
From: Vikas Nanda <[EMAIL PROTECTED]>
Date: April 17, 2005 7:39:57 AM PDT
To:
me
and you can't join two strings in SQL with a '.' like you can in PHP
you should use a + for the two strings. I think what you want is:
AND acct_db.key1 LIKE \"%\" + AllMid_Data.CPU_Hostname
Good Luck,
Frank
On Mar 24, 2005, at 1:33 AM, [EMAIL PROTECTED] wrote:
If you are looking for precompiled win32 binaries you can find them here:
http://kromann.info/php.php or included in the zip files on
http://snaps.php.net
- Frank
> Does Anyone know where can i get the latest and already fixed mssql
extensions??
>
> thank you
>
> --
> PH
and set valid to 0; then
insert a new record. This may not work if you are joining off of the
ID (all related records will still point to the old record).
You could also remove of disable all the UPDATE code from your PHP
pages, no?
Good luck,
Frank
On Jan 11, 2005, at 9:39 AM, [EMAIL PROTECT
ay the body of an article given it's ID.
I've been kind of brief here - but if you need more details please ask.
Frank
On Dec 27, 2004, at 5:23 PM, [EMAIL PROTECTED] wrote:
From: "Daniel A. Betancourt" <[EMAIL PROTECTED]>
Date: December 27, 2004 2:25:11 AM PST
To:
Subject: H
Ramil and Jochem,
Having mySQL format the date is the best solution... thanks!
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
31, 1969 are displayed as 12/31/69.
What am I doing wrong?
Thanks,
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sessions work fine with IIS.
Check you php.ini file for register_globase if that is off (default) you
can only access your variables through $_SESSION[]
- Frank
> can you show some code?
>
> bastien
>
> >From: "Adil" <[EMAIL PROTECTED]>
> >To: [EMAIL
Hi Adil,
You need to configure session.save_path in php.ini. This setting needs to
point to a directory where the IIS user can write files.
If you are running the ISAPI version of php you also need to restart the
web service for the changes to take place.
- Frank
> Hey everyone,
>
(how
long) could you tolerate loosing?
It's a kind of interesting discussion and the only wrong answers are
not to back up and perhaps to back up to the same disk if you want to
be able to recover. But if you answer these questions we'll give you
some options.
Frank
On Oct 27, 2004, at
users browser; you may want to display it but always
look it up from your DB).
-if there is an error what does the error look like? It should not
reveal anything about your data, database, structure,
Good Luck,
Frank
On Oct 4, 2004, at 7:31 PM, [EMAIL PROTECTED] wrote:
From: Stuart Fel
ways of running it on Fedora
Core. I am using RH 7.3 because 7.2 was the last free distro identified and
I had it handy.
Zap me a mail if you need more info - news sites etc.
Cheers,
Frank.
* 1 CPU for the dataserver - you can run it on a multi cpu system with more
than 2 Gb RAM. In a dual CPU
The method doesn't matter, use whatever you like.
Did this quick just for the fun, it seems to work. Set $search to
whatever you'd like to try or to your GET or POST argument.
" ,,, eurpoe" won't cause a problem but " + + + europe" will generate
some odd SQL (although it will work as expected -
mssql_init() is a function used to initialize stored procedures and it was
introduced inphp 4.1.0 (according to the docs). The versions you are
listing for both PHP and FreeTDS are very old so I would suggest updating
these first.
- Frank
> "Damien Babilon" <[EMAIL PROTECTED]&g
That depends on the SAPI you are using. With CGI or FastCGI there is no
problem but with ISAPI or Apache module you might get problems, as the
DBLIB library used to build the extension is not thread safe.
- Frank
> I am currently writing code to write and read data to a Microsoft SQL
2
mssql_field_type() is the function for that.
- 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?
>
>
&g
abilities). But think of cursors just like your
results set - you define them by running a SELECT statement and the results
are put into this cursor and now you can run a loop of some kind on that
cursor.
Personally I can't remember the last time I used one, but I know I have used
one - I
y = "select * from foo where status = "i"";
One last note - if you build your query in different strings be sure to
leave white space between the strings:
Like this:
$myQuery = "select * from foo ";
$myQuery = $myQuery =" where status = 'i' &qu
multaneous connections to 500 or so different MySQL servers? Any feedback
would be appreciated.
thanks
frank dziuba
har, getdate(), 102)
Then change the "." for - and change the getdate() for your date column.
Good Luck,
Frank
> From: "charalambos nicolaou" <[EMAIL PROTECTED]>
> Date: Thu, 06 May 2004 13:13:27 +0300
> To: [EMAIL PROTECTED]
> Subject: Insterting date in an My
of the last post person (and if
you're doing that you might as well add the time and count - now your query
doesn't need a GROUP BY at all).
Good Luck,
Frank
On 3/22/04 9:09 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> From: -{ Rene Brehmer }- <[EMAIL PROTECTED
Hi David,
You problem might be a thread safty issue. the MSSQL extension is not
thread safe (caused by the Microsoft Library used to create the
extension). Use CGI or FastCGI to avoid this problem.
- Frank
P.S. I don't have the full thread of this discussion so I might miss some
impo
elect convert(varchar, getdate(), 11)
select convert(varchar, getdate(), 12)
select convert(varchar, getdate(), 110) /* adding 100 is the same but
with a 4 digit year */
Good luck,
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
You need one ofe the folowing extensions compied as a shared or static
module:
ODBC (UnixODBC)
MSSQL (FreeTDS)
ODBTP
compiling as a shered module does not require recompile of PHP. You just
need to load the extension with dl() or from php.ini.
- Frank
>
> My domain is hosting through a h
amed pipes for the connection, but if the server and the
client uses different protocols you will not be able to connect without
creating an alias.
- Frank
> I am trying to create a connection w' MS-SQL Server to use with php. I
have
> the server name (on our LAN) and my UID & PWD
w */
echo "Category = $Category ";
}
/* now all you need is $Model - $Description - $Price */
$Model = htmlspecialchars($SRecord["ItemModel"]);
$Description = htmlspecialchars($SRecord["ItemDescription"]);
$Price = htmlspecialchars($SRecord["ItemPrice"]
Too true - this is why a page that I promised would only take a few minutes
winds up taking all week.
But it makes steady employment for the QA team...
Frank
On 2/24/04 10:37 AM, "Andy Armstrong" <[EMAIL PROTECTED]> wrote:
> Frank Flynn wrote:
>
>> And if you
y["title"];
> $datum= date("d-m-Y", strtotime($datum));
> $datum is 20-02-2004
> ?>
> I want to show here the events by month for example table with events of
> 02(February) then if there are events from 03(March) another table and so
> one
> How can I make this work do I need to make another query
> Any idea
>
--
Frank Flynn
Poet, Artist & Mystic
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ND `model` LIKE '%".$_GET['search']."%'";
Is it will return many results if $_GET['search'] is very small like one
letter.
Good Luck,
Frank
On 2/24/04 8:20 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> From: "Nitin Meh
sage() 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 to fetch the message if
an error is detected.
- Frank
> Hi Robert,
>
> I've seen your name on a few of t
in MS SQL getdate().
- Have your Stored Proc return only the web_user value to PHP.
Now run a new query on the table where web_user = the value you just got.
Your "Next 10" button only needs to store the web_user value and the number
of the row you're on now. If you need some s
You are getting a message from the SQL Server.
If you increase the values of mssql.min_error_severity and
mssql.min_message_severity (default is 10) you will get more messages if
you descrease the value you will get less messages.
- Frank
> Adam, Thanks for the suggestions. I don't
new class, display it's info*/
echo result["classDescription"]
/* don't forget to reset this */
$thisClassID = result["classID"];
}
/* now display the section info... */
Good Luck,
Frank
On 2/17/04 9:49 AM, "[EMAIL PROT
You need to install the MSSQL Client Tools or alt least copy ntwdblib.dll
from the SQL Server (this will allow connections but not configuration).
- Frank
> I have the php_mssql.dll in the extension directory but when I execute a
> PHP page, I am told that the dll does not exist. This
uot;NOT IN" and drop the group by
but basically we're looking for the unit_ID's of any reservations that
are live any time between your $arrivalDate and $departureDate and then
looking for unit.id that match 0 of them.
Good Luck,
Frank
On Feb 12, 2004, at 2:23 PM, [EMAIL PROTECTED] wrot
Subscribe digest
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Take a look at http://gtk.php.net/apps. Lots of references to code that
will work on both *nix and Win32 systems.
- Frank
> Hi there,
>
> Unfortunately I don't know much Perl at all ATM, and I've suddenly has
this
> job arise that needs me use an ACCESS Database (Yuck)
http://gtk.php.net
- Frank
> Hi there everyone,
>
>
>
> I need to produce a system which uses databases but NOT on a webserver,
I
> heard something about a PHP distro that is being developed which acts
like
> an executable, does anyone know anything of this?
>
I'm guessing that you are using PHP as ISAPI or Apache module and that
might not always work with the MSSQL extension. The library (ntwdblib.dll
from Microsoft) used for this extension is not thread safe. If you switch
to CGI or FastCGI you will not have these problems.
- Frank
> Stua
Hi Matt,
Tables in tempdb are deleted when the connection is closed or when the
user deletes them with drop table #tempname.
- Frank
> Hi Frank.
>
> When does this table get deleted? when the DB connection closes or does
> one have to run a process to clear the temp tables?
>
&
the database.
- Frank
> Thanks for your response Frank, but this is still driving me nuts and
> making me look like a moron at the same time (-:
>
> This simplified query:
> $query = "SELECT distinct convert(varchar(36),a.traineeID) INTO
#tempdata1";
> $query
Hi,
Any table that starts with # is a temp table. You can use
create table #mytemp (...) or you should be able to use the query you
suggest. You just have to make sure you have enough space in tempdb (a
system database)
- Frank
> Hi all,
>
> I've been handed a query which I'
ke[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/local/php4/php-4.2.2/ext/interbase'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/php4/php-4.2.2/ext'
make: *** [all-recursive] Error 1
i see an error, but i dont now what i must do.
Can anybody he
ve to recompile any of your existing modules or
apache.
- Frank
> I have RedHat 9 and FreeTDS. I used tsql to test FreeTDS and it works
> great, connecting to my remote SQL 6.5, 7, and 2K servers, accessing
> pubs.authors.
>
> Now I want to connect PHP to it. I seem to be doing
Hi,
It is also described in the documentation at http://php.net/mssql.
- Frank
> Thanks Jeff, I'll look into FreeTDS.
>
> Matt
>
> [EMAIL PROTECTED] wrote:
>
> >you can use freetds (http://freetds.org) i think there is even an
rpm...
> >Then you just u
simply
copy ntwdblib.dll from the SQL Server tp the web server, but this will not
install the tools needed to change the configuration!
- Frank
> First, I will admit that I am new to PHP. I'm installing PHP on our
Windows
> 2K / IIS server for some users who want to use it. We also host
mssql
functions to handle stored procedures etc.
If you can recompile the Sybase extension, you can disable the definition
of the mssql_* function aliases and that should solve the problem too.
- Frank
> Well, this is the situation:
>
> i have a Win32 server running Apache2 and PHP4
from right now). Is this possible? If so, how. Thanks for the
help.
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
procedures, through
mssql_init, mssql_bind and mssql_exec functions.
It is required that you ink with FreeTDS though.
- Frank
> Yes
>
> You cannot read varchar(>255) data fields.
>
> You cannot easily read ntext and nvarchar (UNICODE) fields.
>
> No direct support for stored
i found that even i have not the php.ini in my SYSTEMROOT, php can still run
... why?
For window XP, should it be placed in c:/WINDOWS? or any other ?
thx for answer!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
need to install the tools.
- Frank
> I got the following error when I tried to connect to MS SQL server:
>
> Unknown () mssql: unable to initialize module
>
> Please advise
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscrib
and retreive the return values.
http://www.php.net/manual/en/function.mssql-execute.php.
- Frank
> Jeson Hi , this is Nabil from PHP list, i wonder if u could help with
the
> following:
>
> I have a stored procedure on a remote Microsoft (stupid) SQL server..
> and I have t
Hi David,
Try this one:
Regards,
Frank
- Original Message -
From: "David Shugarts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 10, 2003 11:23 PM
Subject: [PHP-DB] Date Formatting in PHP
>
>
>
> I have a simple need to reformat
. No attempt is made to relocate rows to
unallocated pages. target_percent is ignored when TRUNCATEONLY is used.
- Frank
> Please forgive me for being somewhat off topic.
> This information is going towards a db class written in php.
> Does MSSQL have an SQL command counterpart to mysql'
That depends on your backend. Some database systems uses \ to escape '
others uses '. In the last case use
$value = str_replace("'", "''", $value);
- Frank
> Don't. addslashes() instead.
>
> Chris Mach wrote:
>
> >does an
help.
Frank
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
You can't split a transaction between multiple calls to mssql_query. The
memory used (in the server and client) are cleared between each call.
You would have to create a batch of statements and execute these with one
call to mssql_query.
- Frank
> I have an opened connection t
Thanks guys for the info; I will speak to my ISP!
Have a nice weekend!
Regards,
Frank
- Original Message -
From: "Rich Gray" <[EMAIL PROTECTED]>
To: "Frank Keessen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday,
and when i'm taking off the LIMIT 1 it will display all the records
in ascending order so also not in random..
Regards,
Frank
ine script
using the mssql_*() functions ? This should work with php 4.3.0, but I
have made a few changes to the code in CVS and I can send you the latest
files if you need them.
This configuration is tested on sevral different Linux configurations and
I use it every day so I know it works :-)
- F
ing --with-mssql=/path/to/freetds.
FreeTDS needs to be compiled with --enable-msdblib, and you need to change
your code (sybase_* should be mssql_*). The upside is access to all the
mssql_* functions.
I'm using this on a Mandrake 9.0 system and it works fine (FreeTDS 0.61)
- Frank
&g
developed to access MS SQL and Sybase servers from
(nix, and I have just tested 'for xml auto' from my Mandrake 9.0 box to a
SQL Server 2000, and it seams to be working.
- Frank
> Folks,
>
> I'd like to use Microsoft SQL Server 2000 XML capabilities for
generating
> query
Hi Alan,
I'm not sure what 'Control Panel PHP script' means ?
What version of FreeTDS are you using ?
Do you use the sybase or the mssql extension in PHP ?
- Frank
> Hello,
>
> Because I am not sure if this is just a PHP issue or a
> PHP+DB issue, I will be posting
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
Your example was not very explicit so I am not sure, but I believe you are
in need of a
WHERE clause. For example;
Select a, b
Hi Gunther,
there was an error in the mssql.php file. I have just fixed that in cvs.
Change line 161 from
$ar = @mssql_fetch_array($result);
to
$ar = @mssql_fetch_array($result, MSSQL_ASSOC);
And it will work on your system
- Frank
> I have a problem with
1 - 100 of 178 matches
Mail list logo
