Recent content by TheSofty

gwinn7, 1) the .msi file on PHP site is well suited for installation in a IIS server environment rather than Apache, so there's definitively a reason for its existence. 2) if you get back from Apache the script itself as text instead of its execution, most probably Apache does't know how to...

You say "I followed the instructions...", but what *exactly* did you do? I usually download the .ZIP file on php.net.

David, why don't you let us see your connection code on line 10? As you know, there are some syntax differences between pg_connect() and mysql_connect(). I use WinXP/Apache 2.0.53/PHP 5.03/PostgreSql 8.0.1 without problems. TheSofty

Dave, a possible cause could be that in the *first* row of the cursor/table resulting from your SELECT the field has a value represented by 3 digits: all subsequent rows will have 3 as max number of available digits. Solution: SELECT 00000 as <field>, ... FROM ... TheSofty

DRJ478, OK, the fog is diminishing! But now I do not find pgsql.so anywhere on my Fedora2 box. Is it in a package other than postgresql-7.4.6-2PGDG.rpm (which I used to install)? TheSofty

DRJ478, excuse my ignorance, but when you write "Uncomment the .so" you mean the msql.so, or another PostgreSQL-specific .so? And in this case, what is its name? How can I load a .so dinamically in a script? I tried uncommenting the line I showed you in my last post and restarting my Apache...

DRJ478, I searched /etc/php.ini for ".so" and the only reference I found is (note the semicolon); ; extension=msql.so in the "Dynamic Extensions" section. TheSofty

DRJ478, in /var/log/messages I see: PHP Fatal error: Call to undefined function: pg_connect() in /var/www/html/provadb.php in line 14 (that is the line I showed above). pg_last_error() returns nothing, I mean I can't echo it in any way. Thanks TheSofty

Hi all, I'm an absolute beginner in PHP world. I'm trying to connect to PostgreSQL 7.4.6 on a Fedora 2 box in my LAN through PHP 4.3.10 installed via RPM. The script I'm using runs OK until this line: if (!$connect=pg_connect("host=$host port=$port user=$user password=$password...

jrumbaug, the best advice I can give you is: keep the .DBC in the same folder of your tables. It's NOT mandatory, but you can avoid many headaches later on. To answer your second question: use the PATH statement in your CONFIG.FPW to have VFP find the data (i.e.: PATH=DATA, where DATA is the...

Your grid is bound to a table/cursor/view, right? So every time you move to a new row in a grid, you're changing the record pointer in its RecordSource. With lnRecNo = RECNO() in the AfterRowColChange() event method I think you'll get what you want. TheSofty

Use GETFILE()

keepingbusy, an old trick for Win98/VFP8 was to be sure that GDIPLUS.DLL was in C:\WINDOWS folder. TheSofty

The short answer is that you have to include all the fields in the GROUP BY clause. For the longer one see SET ENGINEBEHAVIOR in the VFP 8.0 help. It's a new feature. TheSofty

OK. Thanks.