Search results for query: *

What is wrong with this syntax ? Using MySQL 3.23.51-nt UPDATE products SET manu_release_date = (SELECT dates.reldate FROM dates, products WHERE dates.id = products.stock_code ) I get the error: Error MySQL said: You have an error in your SQL syntax near 'SELECT dates.reldate FROM dates...

I have searched and searched... I have to ask... Is there a way to spawn a new page AND re-direct as script at the same time... I am trying something like this... I know this is in PHP ... but it is client side actions that I want to accomplish... <? header(...

I am wanting to generate custom reports with PHP and then be able to print them. Is there any way - I have even looked at window.print() in Javascript - to get rid of the URL and date thing at the bottom of the page and the Title and Page 1 of 3 thing at the top? Peter

I know that this may not be a PHP specific question, however I am wanting to generate custom reports with PHP and then be able to print them. Is there any way (I have even looked at window.print() in Javascript) to get rid of the URL and date thing at the bottom of the page and the Title and...

Hello: I am passing a date from a database to the date function and it returns the wrong month... any ideas why? saledate is currently: 2003-06-21 and date(&quot;F&quot;, $row[&quot;saledate&quot;]) returns Wednesday, but June 21st is a Saturday... can't figure it out... any help...

OK... I am about to develop an on-line financial system that generates checks, receipts, and the like. I am planning to do it in PHP / MySQL. Now the thing that I don't know is how do I generate a formatted report (like a check run) that will be printable on stock forms like an accounting...

Hello: Is there a way in Access to export (or just show for cut & paste process) the table structures in the CREATE TABLE style? I have created tables in Access and I want to convert them to MySQL without having to re-create them manually. Any help appreciated. Peter

OK... here is the first one... what is the difference between a session and a cookie ? The php documentation states that sessions are managed thru cookies... so why use the $_SESSION as opposed to a cookie? question 2 I have a site that uses cookies... my local environment allows for me to...

Hello everyone: I have the following code that works, but the only way it is working is if I hit the database twice to get my $result array back to the top. It is the same query and all I want to do is put the &quot;record pointer&quot; back to the front of the array. I have tried reset()...

I have 2 very complex queries (many Union Selects in each one) and after so much coding Access tells me that the query is too complex. So I split the query into 2 separate ones. Now I want to be able to call both queries (I'm thinking from a third query) and have the results of both queries...

Hello: I am trying to make an individual cell in an MSFLEXGRID control blink the contents added to it. To show that it was the most recent entry. Then when another number has been entered in another cell on the same or another grid turn the current blinking cell off and make the new cell...

Hello: I am trying to validate my data before I allow the move to happen on bound controls using an ADO control. I figured it would be in the data control's validate event, but if I put code in that event the record pointer moves anyway. On an related topic... is there any way to load unbound...

Hi: I am trying to get a DLL to connect to a database and return a TRUE/FALSE based on results... Can anyone point me to a link SPECIFICALLY on this topic. Or help me with this code... All me reading says it should work, but I think I am missing a part on how to register the DLL. I am using...

Hey : I am trying to make a &quot;simple&quot; DLL that accepts userid and password in a VB DLL and using that info connecting to a database and testing for a valid login. I wrote the DLL and registered it (I think) and then wrote the ASP to use it, yet I get an object required message. here...

I have code that depends on the expiry date of a cookie. I can set the expiry date of the cookie, but I can't figure out how to get the value of the Expires property. I tried this... <%= Request.Cookies(&quot;Voted&quot;).expires %> but it calved on me... I know that if the cookie does not...

Hey: I have some cool code that builds a dynamic array based on what I find in the database. But if I get EOF from the database then I don't need the array and it is not created. Now I just need to test to see if that dynamic array exists or not and I don't know how. I have tried this... but...

Someone here posted this reply for launching NetScape in Kiosk mode... I want to do the same thing, but with IE... how can I do this? ==================== Create a new shortcut for Netscape Right click the shortcut just created click Properties add a space and the kiosk switch, -k, after the...

I am developing locally with Access and working fine... when I transfer to a test site using SQL7 I seem to get errors when retrieveing records with memo fields... is there a diference between memo fields in Access and memo fields in SQL 7 ? Any help or pointers appreciated. Peter

I am developing locally with Access and working fine... when I transfer to a test site using SQL7 I seem to get errors when retrieveing records with memo fields... is there a diference between memo fields in Access and memo fields in SQL 7 ? Any help or pointers appreciated. Peter

Is there any way to have access generate SQL commands based on the data in one of its tables, for transfer to SQL 7, or can SQL 7 import data from the .mbd file? We are doing data entry into an access table but eventually want to move it to SQL 7...