Recent content by chillay

Thank you. I updated the post. Does it work for you now? I still can not get it to work correctly though. Thank you.

Hello All I am using the following script to "find text on a web page" and although it highlights the first instance of the text, the page defaults to the top of the page. Does anyone know how to fix this? When the text is highlighted, I would like the browser to go to that portion of the web...

Thank you Jpadie.

Hello Can anyone write a MYSQL query that is somewhat equivalent to the following? CREATE PROCEDURE CountPhoneNumbers AS DECLARE @count INTEGER SELECT @count = COUNT (*) FROM Customer WHERE HomePhone IS NOT NULL Print @count Thank you!

Good advice. Thank you. Chillay

Hello I am testing my query to ensure that it rolls back to the first insert statement. It does not seem to be working correctly. In the following query I do not understand why the first insert statement does not insert a record into the ServicePlans table when I cause a syntax error in the...

This is great information. Although they return the same result I was wondering why the syntaz was upgraded. Thanks! Chillay

Hello Does anyone know why is it best to use the new SQL92 INNER join syntax rather than the SQL89 INNER join syntax? I know it gives the same output and is processed the same but does anyone know why this syntax was created over using a simple WHERE clause in inner join queries? Thanks Chillay

Thank you genomon! Chillay

Is there a basic SQL command to insert an image using Jet SQL. I tried the following in Access 2007: ---- CREATE TABLE Experiment ( Field1 COUNTER (40), Field2 IMAGE ); ----- INSERT INTO Experiment (Field2) Values ('C:\Users\Cecelia Allison\Desktop\Addy.bmp'); ---- The field comes up...

Thank you. Sounds good. Chillay

If I'm creating a Customer table that includes contact info and I require either a phone number or an email address, how can I ensure that both fields cannot be left blank? In other words, a customer's record can have an entry in the Phone column or in the Email column or in both, but it must...

Thank you very much RivetHed. That was so very helpful. I appreciate it. Chillay

I work with Access and have a database that was created by someone else that I now work with. I ran across this in a subform for one of the databases we use and was curious about [form]![combo107]. I use it to select a specific event someone is participating in but don't understand how it...

Thanks. I will look into it. I am looking for a version of SQL Server that is free with no expiration date since I am only using it to debug script. CE seemed to be what I was looking for yet I have errors with nested subqueries. Thanks again! Chillay