Hi Mike
I have heard successful reports of using odbc to connect to db400. I have
not personally done so.
Regards, John
Mike Germain [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am trying to do a query on a database on an AS/400. The database is in
DB400
Could anyone please help me with that query ?
$req=SELECT * FROM tab AS C INNER JOIN inter AS A ON
C.id_tab=A.id_tab WHERE A.id_cat IS NULL OR A.id_cat = 0 ORDER BY
num;
$result = mysql_query ($req,$db);
It works on my machine but not on the server.
Christine
Hello,
I have a little bit difficult question, I need to send email under format
meeting request to automatically update the calendar in outlook, how can I
do that with PHP and what parameters use??
Thank you
Walid
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
eval() might do what your asking for.
I'm no expert tho.
-Original Message-
From: Matthew Tedder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 25 June 2002 7:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP in Database Fields..
Question:
I want to put PHP code into database fields
Thans for awnsering!
OK here is my Query
SELECT entries.id, entries.head, entries.date, entries.author, (catgroup.gid
IS NULL || catgroup.gid = *user-group-id*) AS indi
FROM entries
LEFT JOIN category ON entries.cat_no REGEXP
CONCAT(\\.,category.id,(\\.|$))
LEFT JOIN entgroup ON entries.id =
POST will allow larger form submits as well, like file uploads. GET are for
smaller and faster data sets.
-Mike
Not only that, but POST results cannot be properly bookmarked by the user, whereas GET
results contain the full URI string, therefore can be bookmarked. Good for searches,
etc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 7:47 PM
To: Cosby, Christopher; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] what the heck? (elementary question)
I will regularly use large echo style statements to generate HTML,
especially
I'll dig up some old code I have lying around that did this (may take a
while to find). In the meantime, I did it like this:
1) Create an event in Outlook.
2) File - Save As... - event.ics
3) event.ics is a plain text calendar file. The dates are a pain in the @$$
(DTSTART, DTEND), but the
for building my website i am implementing a tree-style data organization.
for that i have a mysql table called 'jm_tree':
CATID, int(10)auto_increment - Index
PARENT, int(10) -the CATID of
the 'parent' node
TEXT, varchar(40)
http://www.allbrucelee.com/movies/brucelee.asf
José Moreira
Técnico de Informática | IT
TechnicianVila Nova de Gaia, PortugalE-mail: [EMAIL PROTECTED]MSN: [EMAIL PROTECTED]ICQ:
136936120IRC: gray (irc.ptnet.org)
--
PHP Database Mailing List
I am working on a Call Log application for our SA group. I
currently have the database back-end configured and working OK. Right now I
am working with 3 pages, one is to post new entries, the second is a log
view of all entries, and the last is a page that updates an existing entry.
I
One large PHP block is more efficient than multiple small blocks of
php.
It's a tradeoff of multiple invocations of the parser versus having
the parse run through (and ignore) normal text. We have run tests
inhouse that validate the performance difference is fairly small, but
it does exist.
There's a long thread somewhere in the archives of PHPBuilder.com
in regards to getting DB2/PHP to work on an AS/400.
-Mike
- Original Message -
From: John Lim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 25, 2002 12:01 AM
Subject: [PHP-DB] Re: DB400 on AS/400
Hi Mike
Make sure you're exec'ing against the correct database with identical schema.
Different MySQL versions? Schema? Permissions?
var_dump() and cut'n'paste onto the server to make sure the query DOES
run, then look for remote DB connection issues, permissions, database, etc.
Are there multiple
You're going to have to rip open the MS-specific format and
handbuild (or script) your PHP to custom-build that format with
the correct data fields. While it can be done, it's a good bit of
time and energy.
-Mike
- Original Message -
From: Dib, Walid (MED, Stagiaire GEMS) [EMAIL
okay, couple of questions in this one... =)
First...
?=$myData? is shorthand for ?php echo $myData; ? if you care.
With a textarea there is no value attribute.
TEXTAREA?=$myData?/TEXTAREA
Your UPDATE call via sprintf() is okay for the parameter passing,
but you're missing single quotes
You need to have keys in each table to join them together.
Once you have those keys in place, you can match the keys
across the tables and use a WHERE clause to filter the results.
'Luck!
-Mike
- Original Message -
From: José Moreira [EMAIL PROTECTED]
To: Php-Db [EMAIL PROTECTED]
Sent:
Sorry, that was vague. ODBC is a standard of connectivity
and IS supported by the AS/400 platform.
With that said, if AS/400 has ODBC support and PHP has
ODBC support then the two can talk.
-Mike
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL
I am working on a Call Log application, and need to calculate time.
For example, if a page is received at 12:00, the page is returned at 12:10,
and the call is resolved at 14:30... I need to be able to calculate the
time to return the page, and also the time to resolve the call. I am
Versions above just before 4.0 of MySQL can handle direct date math.
Try SELECT date_returned - date_paged FROM pagetable;
It'll work if you have values date_returned and date_paged in the table
pagetable of course :o)
HTH
Martin
NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] 06/25/02 04:40PM
On Tue, 25 Jun 2002 14:29:08 -0700
Michael Robbins [EMAIL PROTECTED] wrote:
I'm looking for a utility that can compare two database structures and
generate a SQL statement that will duplicate the differences.
I'm using mySQL and I have both live and development databases. While
working
The if statement is not working here. Does anybody know why?
$total= 332.06;
$production = 45.11 + 134.38 + 85.35 + 67.22;
print(Total = $totalbr);
print(Production = $productionbr);
if($total != $production) {
print(Totals do not Match!);
}
else {
print(Totals are in Balance);
}
22 matches
Mail list logo