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 orderstatus.
on the same line. Other
than that it looks correct - what is the error?
Frank
From: Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com
Subject: mysqldump
Date: January 1, 2013 3:50:50 PM PST
To: PHP Database List php-db@lists.php.net
Reply-To: erosenb...@hygeiabiomedical.com
Dear
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 chrisstinem...@gmail.com
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 seem like
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: http://www.php.net
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 characters in a string, so can't use
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 5 based website, talking
Sounds like a permission problem. Make sure the IIS user (IUSR_maschine
name) 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 the network
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 the
Unix
like
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 all
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.conf file for differences (use the sam TDS
into the
application upgrade script (a evildoer might find these and use this
account to break in). So you might want this PHP page to ask for a user
name and PW that has these permissions - avoid hard coding this to root,
perhaps there is another account the sys admin wants to use.
Good luck,
Frank
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:
I am
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 directory, so I have
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 converting my clients PHP scripts that are
using
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 rows. But
Query #2) SELECT * FROM
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 system path set to your Windows PHP directory
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_dir = C:\PHP5\ext\
PLEASE NOTE that I disagree
withstand. BTW you prolly 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
) 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 returns in a text field
Good morning -
I'm trying to get
fine 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 php-db@lists.php.net
Subject: SELECT
Reply-To: [EMAIL PROTECTED]
I am trying to put together a SELECT
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
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 PROTECTED]
Date: September 19, 2005 11
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, [EMAIL PROTECTED
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.
PHP developers are saying
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 application
(uh
=
therowkey')
Cheers, Frank.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
. 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 techiques.
I'm using PHP 4.3.11
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 it so when people
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 List (http://www.php.net/)
To unsubscribe, visit: http
FROM purchaseItems WHERE orderID = '789' and itemIDs =
whatever
Good Luck,
Frank
On May 20, 2005, at 5:02 PM, [EMAIL PROTECTED] wrote:
From: mayo [EMAIL PROTECTED]
Date: May 20, 2005 4:45:05 PM PDT
To: 'Miguel Guirao' [EMAIL PROTECTED], php-
[EMAIL PROTECTED]
Subject: RE: [PHP-DB] multiple
INTO 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 3:28 PM, [EMAIL PROTECTED] wrote
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
that their posting has been approved
).
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 Reilly [EMAIL PROTECTED]
Date: April 23, 2005 2:05:44 PM PDT
To: php
://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: php-db@lists.php.net
Subject: php and tables
Hi
I
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:
From: NIPP, SCOTT V \(SBCSI\) [EMAIL PROTECTED]
Date: March
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
--
PHP Database Mailing List
find the original record 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
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/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 PROTECTED]
Subject: [PHP-DB] IIS/PHP question
Date
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,
I'm trying
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 6:57 AM, Perry
to be 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
).
-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 Felenstein [EMAIL PROTECTED]
Date: October 4, 2004 1:28:04 PM PDT
To: [EMAIL PROTECTED]
Subject: Multi
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] wrote in message
news
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
2000
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 remember looking it up.
Frank
--
Frank Flynn
Poet, Artist Mystic
--
PHP Database Mailing List
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' ;
$myQuery = $myQuery = order by ... ;
Good Luck,
Frank
On May 29, 2004, at 7:36 AM, [EMAIL
connections to 500 or so different MySQL servers? Any feedback
would be appreciated.
thanks
frank dziuba
(varchar, 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 MySQL table
Hi everyone,
I want to created
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]
Date: Mon, 22 Mar 2004 18:12:35 +0100
To: [EMAIL PROTECTED]
Subject: Looking for simpler way to do this...
I'm working with PHP 4.3.0 w. MySQL 4.0.14b
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
important
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 hosting
face=Arial size=-1? echo($Description); ?/font/td
tdfont face=Arial size=-1? echo($Price); ?/font/td
?
}
?
Good Luck,
Frank
On 3/8/04 12:50 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
From: Aleks @ USA.net [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Mon, 8 Mar 2004 15:50:01
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 (work via MS-ODBC driver
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 Mehta [EMAIL PROTECTED]
Date: Tue, 24 Feb 2004 13:18:24 +0530
To: [EMAIL PROTECTED], -{ Rene Brehmer }- [EMAIL PROTECTED]
Subject: Re: [PHP-DB] how
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
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'd like to make wild carding optional
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 the ODBTP posts. You're one
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 want
button only needs to store the web_user value and the number
of the row you're on now. If you need some sample code I can send you some
but really it's pretty straight forward in the PHP side.
Good Luck,
Frank
--
Frank Flynn
Poet, Artist Mystic
--
PHP Database Mailing List (http
*/
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 PROTECTED]
[EMAIL PROTECTED] wrote:
From: mayo [mailto:[EMAIL PROTECTED
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
Subscribe digest
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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] wrote:
From: amanda kerdal [EMAIL PROTECTED]
Date: February 12, 2004 6:07:38 AM PST
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?
Any help would really
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) but in a
windows-style
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
Stuart wrote
to 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 .= FROM tblSignIn_trainee a;
$queryresult
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?
Thanks,
Matt
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'm trying to get
-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 help me?
Thank you.
Frank
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 something wrong. RH9
ships
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 use the mssql_* functions built into php
hth
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 SQL
Server
7
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.3.2 as a module
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 procedures.
-- bob
On Mon, 1
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
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 unsubscribe, visit: http://www.php.net/unsub.php
--
PHP
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 to connect to it remotely
Hi David,
Try this one:
?
function formatDate($val)
{
setlocale (LC_ALL, '');
$arr = explode(-, $val);
return strftime (%A %e %B %Y, mktime (0, 0, 0, $arr[1], $arr[2],
$arr[0]));
}
echo formatDate($DatePick);
?
Regards,
Frank
- Original Message -
From: David Shugarts [EMAIL
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 anyone know how to strip a ' from a string? It's causing errors
for my
sql
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's Optimize or
postgresql's Vacuum??
Thanks for any
.
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 to MS SQL
all the records
in ascending order so also not in random..
Regards,
Frank
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, March 02, 2003 2:36 AM
Subject: [PHP-DB] RE: [PHP] Random
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 :-)
- Frank
Hi
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 this message
(seperately
is 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 results in XML. It is very easy
--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
Hi Frank
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,
If I have a database x with populated tables and I would like to copy it
to another empty database for Testing purposes, how is that done through
phpMyAdmin?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
).
- Frank
Do you have php_mssql.dll extension loaded?
Check better with phpinfo();
Radovan
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
Hope someone can help me with this.
I need to connect to a MS SQL databas
should not use ip:port as your host name. Port 1433 is the default for
both MSSQL and FreeTds. If you use any other port number you should
specify this in freetds.conf.
- Frank
Hi there,
Hope someone can help me with this.
I need to connect to a MS SQL database but my attemps fail once and
again
According to the specs for ODBC (and SQL92) it is ok to return -1 for the
number of rows, as the correct number might not be available until the
last row has been fetched.
- Frank
[EMAIL PROTECTED] wrote:
Hello everyone,
We are running an old database system called db/c and attempting
Take a look at the documentation:
http://www.php.net/manual/en/function.mssql-execute.php
- Frank
Hi gurus,
I am new user to PHP.
Does anyone here work with SQL server with PHP, please show me some
codes about how to call a stored procedure in a SQL Server Database.
how to add
1 - 100 of 163 matches
Mail list logo
