Search results for query: *

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...

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!

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...

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

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...

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...

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...

I am using "Microsoft SQL Server Management Studio Express 2005" - I am running the following Transact SQL Query: SELECT Customer.FirstName, Customer.LastName, Customer.HomePhone, (SELECT MAX(Orders.OrderDate) FROM Orders WHERE Orders.CustomerID = Customer.CustomerID) AS LastOrderDate FROM...

Hello there Given the following: ------------------ BEGIN TRANSACTION INSERT INTO ServicePlans (PlanID, PlanName, PlanDescription, PlanPrice, DiscountedPrice) VALUES ('C1001', 'Tele-Training Course', 'Course on Telecommunications', 45.00, 35.00) SAVE TRANSACTION Insert1 INSERT INTO...

I am designing a web site with a sql server 7 backend. Right now I am just typing the info into the fields in the tables, but I am finding that when I do this, it is putting extra spaces at the end of what I typed in. Does anyone know why this would be happening and how to stop it? It is...

Hello Is there a way to combine the following 3 UPDATE statements to avoid executing each statement one-by-one? UPDATE ServicePlans SET PlanName = 'Long Distance (In/Out of State/Country)' WHERE PlanName = 'Long Distance A'; UPDATE ServicePlans SET PlanName = 'Long Distance (Limited States)'...

Hello there I have many systems written in VB6. All but one are front ends to a SQL Server 2000 db. The other front ends ACCESS 2000. I have a ton of SQL statements in the code (albeit, simple statements). Most of the statements are SELECTs. Since I started this course I have been replacing...

Hello I secured my Access database and setup users and groups. When I open the database it prompts me for a userID and password which is great but I want to send this database to someone else via e-mail and I want the database to prompt the user for a userID and password. I noticed that when...

Hello CREATE TABLE Speed ( ID# CHAR (50) Primary Key NOT NULL, Slow BIT, Fast BIT, Faster BIT, Fastest BIT, ); How do I create a query where only one of the last four fields can be true the other ones have to be NULL Thank you, Chillay

Hello I have this code in one of my form. When I try to run it I get an error message about "SQL expression is too complex" whenever I have more than 25 rows in my GroupAttendance listbox. The code below works fine when I have less than 25 items. Is there a limit on how many rows you can...

Hello I need help formatting a date in a column to today's date with ccyymmdd format. Thank you. Chillay

Hello I am trying to capitalize all text in one specific column. I am unable to find the button or command to make all lowercase text ALL CAPS. Can anyone help. Thank you. Chillay

Hello I created a database that I want to send via e-mail. I did not apply any security but when they open the database it says the following: The database "Play.mdb" is read only. You won't be able to save changes made to data or object definitions. This is a problem because the user needs...

I am trying to combine 2 queries. The following query shows the HOH (Head of House hold) with no children: SELECT HOH.HOHID, HOH.Lastname, HOH.Firstname, (Select Count (*) From Children Where HOH.HOHID = Children.HOHID) AS TotalChildren FROM HOH WHERE (Select Count (*) From Children Where...

I created the following table using the MONEY datatype but all of my queries will not display a dollar sign in the output. How do I display a dollar sign for my outputs in the AccountPrice column? CREATE TABLE Account ( AccountID CHAR(20) PRIMARY KEY NOT NULL, AccountName CHAR(30) NOT NULL...