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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lyric0n

  1. lyric0n

    Serialize Question

    Hello, I have an application that dumps a date into a MySQL table with object type of text. It is dumping a date into the table, but it doesn't store it as a date, I believe it is running it through a serialize function, then putting it in there. So a date of 6/10/2007 becomes...
    • lyric0n
    • Thread
    • Replies: 1
    • Forum: PHP
  2. lyric0n

    Drop Down Question

    Hello, I would like my users to select an item from a drop down, and upon doing so, the page will refresh and get data from a SQL table, then populate the data into a few fields. I know how to do the SQl portion, and populating the data, but I am not sure how to get it to trigger the event. I...
  3. lyric0n

    Multithreading and SQL

    Hello, I currently have an application that launches multiple threads of a function, which then go, read data from various servers, and post the data into SQL. Due to having so many threads running at once, I would like to use the same connection. I am having a problem though when I launched...
  4. lyric0n

    Created Date/Time

    Is there anything that I should add to make sure that the SQL table will automatically insert the proper data and time when a record is inserted/modified? Thanks.
  5. lyric0n

    Created Date/Time

    Here is what I have tried, but I get errors... CREATE TABLE splash ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100), desc_brief varchar(1024), posted_dt as date default current_date rev_dt as datetime on update current_timestamp...
  6. lyric0n

    Created Date/Time

    Hello, I would like to keep a row in my record that contains information on when the record was created and one when the record was last updated. What is the easiest way to go about doing this in MySQL? Thanks, Chris
  7. lyric0n

    Getting data back from a stored procedure

    The problem ended up being on the SQL side. The SQL Manager returned the right values, but apparently there were some extra spaces being added to the values before going into the stored procedure, so a RTrim on incoming variables did the trick. Thanks for the help, Chris
  8. lyric0n

    Getting data back from a stored procedure

    If I use the code above, it is blank, but if I give Parameters(0) a value before I execute my statement, then I get that same value that I assigned back...
  9. lyric0n

    Getting data back from a stored procedure

    I've actually tried that, but with no luck...any other ideas?
  10. lyric0n

    Getting data back from a stored procedure

    Hello, I have a stored procedure which takes 3 variables in, modifies one of the variables, which is a bit, then returns it. How would I capture this response with Visual Basic 2005? I have written below what I have tried... Thanks, Chris...
  11. lyric0n

    Case Statements and Stored Procedures

    Hello, I would like to pass 3 variables to a Stored Procedure, then query a table on one of those variables, and if there are no results in that table, then insert the data, if there is data, I need to update the data. I have pasted what I have below but ran into issues checking my results, any...
  12. lyric0n

    SQL 2000 and Case Statements

    Thanks!
  13. lyric0n

    SQL 2000 and Case Statements

    Hello, I have the following data and I need to have the result listed below, but when I try to use case statements, it fails. Could someone take a look and see if they can see what I am doing wrong? Table1 IDKey 1 2 3 4 Table2 IDKey | Name 1 | John 2 | Jane Table3 IDKey | Name 3 |...
  14. lyric0n

    Join of Two Tables

    I appreciate your response. When I saw the way these were setup, I was disappointed, but unfortunately, that is the way the application works and I can't change it :( I have run into a new query with a bit more complexity and I was wondering if you could help. What if I wanted to see only users...
  15. lyric0n

    Join of Two Tables

    Hello, I have two tables that I am trying to join together to create a particular view, but I am have a difficult time coming up with the correct query. One table looks like... Uid | Login 1 | John 2 | Paul 3 | Sally The second table looks like Uid | Fid | Value 1 | 1 |...
See more

Part and Inventory Search

Back
Top