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...
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...
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...
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.
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...
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
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
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...
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...
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...
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 |...
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...
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 |...
Hello,
I am working with a different tables and I need to make various queries in my application. I am able to establish a connection to my SQL 2000 server and use the reader to read the first table, but when I try to use another reader (and the same connection) to read another table, I get an...
Hello,
I have a process which launches multiple threads of a single class, passing two variables into the class. Once I have launched all of the threads, I need a way to check if they are done running before proceeding onto the next set of code. How would I check that?
Thanks,
Chris
ESquared, unfortunately, I didn't design this table, I am just using it...
Okay, so now I have a function which I can call like below...
SELECT * FROM Split('abc,def,123',',')
And it returns abc,def,123 on their own rows. How would I get this to input a column from another SQL table...
Hello,
I need to have data split, but apparently SQL doesn't support this by default. Below is an example of what I have and need...
IDKey | EmpID
1 | 101
2 | 101,102
3 | 103
4 | 101,103
...
What I need returned is just a list of unique employee ID's, so just a list...
Does anyone know how to go about querying devices for their SNMP information via a VB 2005 application? I am new to VB and Google hasn't given me much luck so far...
Chris
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.