Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: chillay
  • Content: Threads
  • Order by date
  1. chillay

    Add Control + F feature to a Web Page

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

    MYSQL equivalent query

    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!
  3. chillay

    IF @@ERROR <> 0 ROLLBACK TRANSACTION not working

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

    SQL92 INNER Join Syntax

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

    Insert a .BMP image using jetSQL

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

    NULL datatype

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

    SQL within a subform

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

    Transact SQL Server 2005 "Error"

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

    Display @@ERROR

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

    Extra spaces when entering data

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

    Combine multiple UPDATE statements

    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)'...
  12. chillay

    SQL in-line code vs stored procedure

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

    Prompt user for userID and password after sent via Email

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

    True/False NULL fields

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

    INSERT Statement: Limit on how many rows you can attempt

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

    Format Date in a Column to ccyymmdd Format

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

    Make all text ALL Caps in Excel

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

    Take "Read Only" off the database

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

    Combine two queries

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

    Displaying dollar signs in output

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

Part and Inventory Search

Back
Top