[PHP-DB] MSSQL Identity Column

2001-04-12 Thread Alarion
Hello, I need a way to tell if a specified column is an identity column or not. All PHP seems to be able to tell me is the name, type and size of the field. any help would be appreciated thanks, >-< Sean Finkel Webmaster - R

[PHP-DB] MS SQL server 2k and php4 on win32

2001-04-08 Thread alarion
Well, I just started working on implementing SQL Server support in my database abstraction class. I downloaded and installed the SQL2k evaluation from MS and I can connect through DBArtisan and through the SQL Server Query tool. However when I try to do it through PHP, it just sits there, and caus

[PHP-DB] Virus alert

2001-02-12 Thread Alarion
Hey everyone, In case no one has caught it yet, I think I remember seeing a couple emails go through here this morning entitled "Here you have, ;o) " with an attachment "disguised" as a jpg of Anna Kournikova. I rememebr seeing the subject but I deleted it cause the subject didn't interest me. An

RE: [PHP-DB] Can you recommend a development tool?

2001-02-09 Thread Alarion
development tool? Doesn't DW4/Ultradev now support PHP? regards, jaxon > -Original Message- > From: Alarion [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 09, 2001 4:20 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Can you recommend a development tool? > > >

RE: [PHP-DB] Can you recommend a development tool?

2001-02-09 Thread Alarion
Yeah, I just downloaded the DW4 trial last night, and haven't had a chance to use it yet, but I read that that was one of the new features - It's about time :) I don't know why they would change the keyboard shortcuts around in version FOUR.. *sigh* Sean -Original Message- From: Ru

RE: RE: [PHP-DB] Can you recommend a development tool?

2001-02-09 Thread Alarion
Yes, I was talking about "F10". It's not the most "convienent" since it covers your WYSIWYG window, but I have created whole sites in both PHP and ASP this way, and it works just fine. I tried editplus, but I wasn't impressed with the interface - I then tried Textpad and fell in love ;-)

RE: [PHP-DB] Can you recommend a development tool?

2001-02-09 Thread Alarion
On the contrary... I use Dreamweaver for layouts and then use either it's integrated editor for PHP or fire it up in Textpad. No code reofmatting and it works seamlessly. Sean -Original Message- From: Daniel Rezny [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:01 AM T

RE: [PHP-DB] arrays

2001-02-06 Thread Alarion
[PHP-DB] arrays Hello, "Alarion"! You wrote: > I want to loop through a result set, say with ODBC, and > use the > "fetch_array" function for each row. Now, What I want is > a an array of all > the rows, so I could then access the "Name" column in Row >

RE: [PHP-DB] arrays

2001-02-04 Thread Alarion
2001 5:20 PM To: Alarion Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] arrays Like this: $blah = "hello"; $miaow[$blah][5] = 3.14; ( is the same as doing $miaow["hello"][5] = 3.14; ) - Siggy - Original Message - From: "Alarion" <[EMAIL PROTECTED]> T

[PHP-DB] arrays

2001-02-04 Thread Alarion
Hello, Well, I haven't used arrays in PHP too much and am wondering how I might go about this: I want to loop through a result set, say with ODBC, and use the "fetch_array" function for each row. Now, What I want is a an array of all the rows, so I could then access the "Name" column in Row 5 l

RE: [PHP-DB] MS-SQL Error Message Replacement

2001-01-24 Thread Alarion
well, one way would be to place a check before the delete statement. check to see if there are any child records and then only send the delete statement if it is ok to delete :) -Sean -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 24,

RE: [PHP-DB] Viewing the DB

2001-01-24 Thread Alarion
This was taken from one of the doc's on IBM's site: SYSTABLES contains a row for every table and view in the SQL collection. It tells you if the object is a table or view, the object name, the owner of the object, what SQL collection it is in, and so forth. The following sample statement displa

RE: [PHP-DB] Child tables in MySQL

2001-01-18 Thread Alarion
that info. Sean -Original Message- From: John Starkey [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 12:14 AM To: Alarion Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Child tables in MySQL Forgive me.. newbie alert :} I'm trying to make a user homepage with prefs. But I&#x

RE: [PHP-DB] HELP! Manage MySQL

2001-01-17 Thread Alarion
SciBit (http://www.scibit.com) creates a product called Mascon that lets you connect to remote MySQL databases. It's a pretty decent tool and it's not that expensive (it's like $50 I think). Or, you could install phpMyAdmin if you have a web server and php running :) Sean -Original Mess

RE: [PHP-DB] DELETE FROM.... Question

2001-01-15 Thread Alarion
ent_id=5 (Which is a valid value for the event_id field). Any more ideas anyone? and line 29 is that code that I put in, and it doesn't delete it still. Thanks for the help so far, I appreciate it! -Ken - Original Message - From: "Alarion" <[EMAIL PROTEC

RE: [PHP-DB] DELETE FROM.... Question

2001-01-15 Thread Alarion
Try: mysql_db_query ("DELETE FROM events WHERE event_id = " . $event_id); I have had better luck with "mysql_db_query". Sean -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 3:50 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] DELETE FROM..

RE: [PHP-DB] OCI8 and Listener

2001-01-15 Thread Alarion
The server (that is running the actual Oracle Database) has to have the listener running. If you can connect with SQL*Plus (the Oracle provided SQL interpreter) then you should be able to connect with PHP. Not sure what the error you are receiving is though as I don't have a reference here.

RE: [PHP-DB] Problem width SQL on PHP4

2001-01-14 Thread Alarion
you need to "enable" the mssql extension. I don't have the php.ini file here with me, but search the ini file for "extension" and you should come to a list of them that are commented out. just uncomment (by deleting the leading ";") the one for the extension you need and then shut down IIS and re

[PHP-DB] PHP "confirm" function?

2001-01-14 Thread Alarion
Ok, I am trying to add a "yes"/"no" dialog for a delete operation and I was attempting this via the javascript "confirm" function, but no matter if I click yes or no, the php code block still executes. I tried this way: - if(!confirm("Are yo