Search results for query: *

I have a query that is getting me ALL the records from two tables. For one application I have I only need the last 30 records. I tried Limit 30 but that only got me the first 30. The table is ever growing so I will never know the number of records in the tables until I run the query. Here's...

I see what you mean. I guess since my result is being passed to BaaGrid and I am setting the column names there it all works out. :) Lucky I guess Thanks

Thanks for the reply. Actually I JUST figured it out and you are right I went to the wrong forum. But haer is what I used and it works as I need it $sql = "Select FROM_UNIXTIME(stime,'%h:%i:%s %D %M %x'),direction,Trunk,Source,destination,CallLength from export where Trunk = 'nexVortex'"...

I have some log entries that have the date / time in epoch time. It is in a MySql db and I have a query to show everything I want. The problem is how do I change the epoch time to human time / date when the query is run? The query I am using is: $sql = "Select...

That did exactly what I needed. thank you very much!

Here's the problem I am trying to deal with. Normally when I use my CRM system to add a new product to my inventory I get the option to make it taxable. This is reflected in the producttaxrel table with the new productid, taxid, and taxpercentage entered. This works fine when I just add...

actually would it be just as easy if producttaxrel table was empty, then an insert used? The producttaxrel table is used to indicate within my system which productid would be taxable using the other two fields. the common fields would be productid in any case Thanks

I am trying to update a table with info from another table and also set two fields with the same info for each field. The first field productid will need to be inserted into the producttaxrel table with the contents of the same field in the products table. Here's my query: Update...

Well, I tried $cf_565="7629"; Where I knew the 7629 had something in its records for the query. No luck , I got nothing in the update query. Any other suggestions? Do I have the queries right considering the other queries I have going on, could they be interfering somehow?

Thanks for the speedy reply! I will write a query to make sure I get that cf_565 info. I'll try a $cf_565 = xxxx to see if that works and I 'll clean up the other things you mentioned. I'll report back Thanks Again

The $id is used elsewhere within the script I am about to upload. So I know it is OK. I tried to use a known good number instead of $cf_565 leaving the $id and I still didn't get the table update I am looking for. So here is my code, I am sure it is very sloppy but until now it appears to...

I have a select and an update query that work perfectly if I manually enter the record numbers for cf_565, and id. The fields get updated as they should. as soon as I try to use the variables $cf_565 and $id it fails. I get no error messages. I would also like to use an IF statement to...

Thanks That works beautifully!

thanks! But when I run the query I get: #1054 - Unknown column 'vtiger_quotes.quoteid' in 'on clause'

I want to change a field using two other fields. I have no problem getting the fields I want in a Select query but for some reason I have a mental block on how to do an update, since the information is in several tables. Here is the select Query that works: SELECT vtiger_quotes.quoteid...

I apologize jpadie! I did not use the code you provided just above until just now. It worked! It even kept the original files, that is a bonus! Thank you !!

Well, going into CP and changing all the files to 0755 and the script to 755 got rid of the error but it didn't cnage the names nor did it throw an error. I just got a blank screen. I have all the files and the account/phone list, and the script in the same directory under my web root. I am...

All I get is "500 - Internal Server Error" Common reasons for this error are: * Incorrect file/directory permissions: Above 755. In order files to be processed by the webserver, their permissions have to be equal or below 755. You can update file permissions with a FTP client or...

Can't get a command prompt, my server is on a shared Linux system at my website. Using FTP I changed all the file properties to 0666, I kept getting an error saying that I couldn't execute files with permissions above 0755 from my provider. The error handling code produced no errors. Maybe...

Geates, I got something wrong. Don't know what. I am still getting the vbs error Bad file name or number.