Search results for query: *

Thanks jpadie, I'll mess around with your sample code. I am totally new to php, I have done a lot of database work, but not with php. I agree that the ID should come from another table, but this is just something I threw together to start playing around.

Phil, You are a genius! That's exactly what the problem was, once I added the php at the end of the line it worked. Thanks so much for sticking with me and helping me resolve it. Hopefully I will have more intelligent questions as I go along. I am quite familiar with database work, but totally...

Phil. The a print as the first line of process.php does not show up so it looks like process.php never runs I open inputform.php by putting this on the address bar of FireFox localhost/inputform.php I tried this in Internet Explorer just in case it was a browser issue but the same thing...

The insert does not seem to be the problem, I tried your code sample as follows and it does insert the record: <?php mysql_connect("localhost", "john", "Maintenance1") or die(mysql_error()); mysql_select_db("comptechdev") or die(mysql_error()); mysql_query("INSERT INTO clocks...

Thanks Phil, Here is the link to the post in PHP From what I can see the process.php script never runs, I tried introducing an error on the first line and I never get the error. On the other hand I introduced an error in the query.php script, that throws the error on the screen as well as...

I am trying to learn php to manipulate MySQL data. I setup a simple input form and a script to insert a record to the database. I tried the code in a working web site which is hosted on GoDaddy and it works fine, but when I try it in my local practice machine it won't insert the record and I do...

Phil, There is something strange going on. I turned on error reporting in php.ini and also added your suggested code to the process.php. I even went as far as removing a semi-colon to introduce an error, but still when I click on the Process button, the process.php tries to run, but still get a...

r937, Good idea, I'll post it in the PHP forum as well. What makes me suspect a setting in the MySQL setup is that the code works as is in a live web server. I also tried querying the test database after I posed the message and it works, this tells me that at least the connection to the DB is...

I am trying to learn php to manipulate MySQL data. I setup a simple input form and a script to insert a record to the database. I tried the code in a working web site and it works fine, but when I try it in my local practice machine it won't insert the record, but I do not receive any errors...

Ian, LineTotal={SorDetail.MPrice}*{SorDetail.MOrderQty} I am suppressing detail lines, but when I show them I see 37 detail lines (for this particular customer/date) for 33 orders. If I do a summary field on the SorMaster.SalesOrder field it gives me an incorrect count of 37 orders, but if I...

I am using CR-2011 to extract daily sales order totals. The orders/totals have to be grouped by salesperson by customer and by order. In the order detail table I don't have a line total, I created a formula for this purpose, I then created 3 summaries to add the total of all like totals, the...

Thanks again for all your help and very informative reply. We put together lighting fixtures, our inventory never has decimals, no one wants to buy half a lamp ;~)

Thanks a lot for your help guys. Olaf, Your suggestion of using "DataType','B' worked, it eliminated the "not a table" error. Unfortunately I am stuck with the SQL table design, this is part of a Microsoft Dynamics NAV ERP system and I can't change it. Thanks also for the tip to eliminate...

Hello, I am using VPF 9.0 SP2 trying to extract data from an MS SQL Express 2008. I am getting an error of "is not a table" when I try to append from an offline view. I tried deleting and re-creating everything, but I am still having the problem. I can do an "use vbom" to open the offline view...

Hello, I am working with VPF9 SP2 pulling data from an MS SQL 2005 server. I create views and sometimes I have to delete them to recreate them with different criteria. If the view I am trying to delete does not exist I get an error and the program stops, is there a way to trap this and deal...

Hello, I am running VFP9 SP2 to extract data from an MS SQL 2000 DB. I would like to use a field on a VFP stand alone table as a list for the WHERE clause, but I am getting an error. I would like to know if you can see what I am doing wrong from the code I am using below: CREATE SQL VIEW...

Gary, Is there a way to have this setup as a parameter where one of the options can be All for no TopN sorting or a number to use as the TopN parameter? Thanks.

Thanks a million, I was missing enclosing the (Discontinued=true) I had it as discontinued=true

I am using VFP 9.0 SP2 and need select records based on an MS Access Boolean true/false record. I am stumped, I have tried many different ways using =0, =false, etc. Is there a way to make this work? I will greatly appreciate your feedback.

Thanks Nro. That worked great.