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!

  • Congratulations SkipVought 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: *

  1. specialist

    move record from table1 to table2 THEN delete from table1.

    Greetings Double T'ers- I looked up and down in the forum for an answer to my question to no avail. Alas, I am stuck with a fairly routine problem and hope to get some expert advice from you. Here is my issue: I would like to take a record in table, called 'table1' and move it to another...
  2. specialist

    BASIC PROBLEM'S ANSWER ELUDES ME! JOIN AND IDENTITY

    maswein- thank you for your reply. these tables do not have the same number of rows. tbl main has about 240 rows and tblRandom was recornly created. the idea behind this is to add new functionality to the aplication which is a password retreival function. The function checks the email ( and...
  3. specialist

    BASIC PROBLEM'S ANSWER ELUDES ME! JOIN AND IDENTITY

    Greetings- This may be really simple, but the answer skips me at the moment. I would to add the value of the "ID" column from the main table "tblMain" into another table called "tblRandom". I just cannot seem to get it to work. I am wondering if it has to do with the identity seed in the main...
  4. specialist

    ALT Attribute on image - can you set time lengh?

    thanks everyone, I was looking fr an alternative to onMouseOver but I guess this is not the best way!
  5. specialist

    ALT Attribute on image - can you set time lengh?

    Hello- I was wondering if there is a method in which one could set a time limit on the alt attribute on an image. For example, if I have a really really really long alt image attrubute the alt text will only stay open for around 8 seconds. Is there a way I can change that to 30 seconds? Any...
  6. specialist

    check to see if a session variable is valid (enduser loged in)

    Hello! A very easy answer, but... I really have been beating my head against the wall trying to figure this out but for the life of me i cannot! Here is the deal: I have an intranet application which requires endusers to login with their username and password. the username and pword are...
  7. specialist

    CREATE link and UPLOAD binary to SQL via ASP

    kisasama- thanks for the advice and the links. I'm going to use them as my 'jumping off point' to make this work. I'm certain I am not the only person who needs this functionality on one of their applications. The previous version of this app has the files being stored directly in an access...
  8. specialist

    CREATE link and UPLOAD binary to SQL via ASP

    kisasama- thank you for your reply. I was hoping to do this without the support of a third-party component. Is there a way I can do this on my own? -Mike
  9. specialist

    CREATE link and UPLOAD binary to SQL via ASP

    Greetings- I must create an application with the option which allows end users to upload files to a SQL database. Instead of storing the file in the database itself, I would like to have ASP create the URL where the file will reside on the server, and also upload the file itself. My queston is...
  10. specialist

    Line Break in loong URL causing table to expand

    All- Perhpas I mislabeled my post. I was able to perform a line break via Word-Wrap attribute in css. There is an article here: http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/properties/wordwrap.asp jeepxo, pkailas, trollacious thank you for reading and...
  11. specialist

    Line Break in loong URL causing table to expand

    Greetings everyone- I have a question I would love to get advice on. I have a recordset with a few very looonggg urls which push the lengh of the table out and I was wondering if there was a way to add a line break either via ASP or within the stored procedure to add a line <br> break after...
  12. specialist

    how to extract specific data from FUYNCTION

    Chris- Just uploded and it worked like a charm!! Thank you very much! Mike
  13. specialist

    how to extract specific data from FUYNCTION

    greetings- is there a way to extract specific information from a function? For example: Function FindTOTAL_OPEN_123 FindTOTAL_OPEN_123 = FindOPEN_ALA + FindOPEN_ALA_CAT2 End Function Say I wanted to count the number of records in this function which had a value of: store_id = 123...
  14. specialist

    Exiting the IT Environment

    BocaBurger- Everything is fine, I just wanted to call & say thank you :) -Mike
  15. specialist

    Exiting the IT Environment

    reguardless of what you do, how many of you actually wake up in the morning and look forward to going to work? If not, can you envision yourself waking up each morning and going to a job (any job) you sincerely enjoy? Thats the key right there. Doing what you enjoy. If you no longer enjoy it...
  16. specialist

    ADVICE ON BEST PRACTICE: Storing Binary data in SQL

    SQLSister and Donutman- First off, thank you for the insight as to how to tackle this issue. I appreciate the advice. Just to add one important bit of info: there are no images files being stored (no jpg, gif, etc). These files are mostly .doc, .zip, and a few .pdf files. No images at all...
  17. specialist

    ADVICE ON BEST PRACTICE: Storing Binary data in SQL

    Greetings- I am in the process of moving a DB from Access to SQL for an application and one column holds an OLE OBJECT in the access db, which converts to Image datatype in sql. I am not sure if I would like to hold the images, zips, docs, etc inside the db as it seems to bloat the db...
  18. specialist

    Count records between start and end dates !

    greetings- I am trying to run a query which will count the number of records in a table but just cannot seem to get it working! The background is this: If a record is active, it has a 'Status' of '1', if it is pending, it has a status of '2'. What I am trying to acomplish is to get a count of...
  19. specialist

    format cells after exportng to excel

    good day- I am trying to export a report from an asp page to an excel file but I'm having some difficulity formating the cells in xls. I am exporting with the <% Response.ContentType = "application/vnd.ms-excel"%> method. There are two tables in this report and each has different width...
  20. specialist

    ERROR '80040e14' : Incorrect syntax near '=' -- but WHY ??

    DreX- Once again, you are correct. I had the AUTONUMBER field in the .mdb which did not move over in the migration to SQL. I have since droped and recreated the table with the SQL version of Autonumber which is setting the IDENTITY to "Yes" in the table properties. Thanks again, I know who...

Part and Inventory Search

Back
Top