Search results for query: *

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

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

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

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

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

Hey guys, I have a few questions about getting SNMP information off of switches. I need to pull the MAC address and port it is located on, and I have a SNMP string which will do that (.1.3.6.1.2.1.17.4.3.1.2), but there is one problem I have with it. When I query the switch, I need to...

I am having trouble finding out how to query a SQL database. All I need to do is find out how to make the connection to the SQL database, query a specific string, and then read and move through the data returned. I have tried looking for this, but can't find any answers that seem to work...

Is there a way to check if a file is in use before I try and open it? I've looked at the options under the Scripting.FileSystemObject but I haven't seen anything I could make work together properly. Thanks, Chris

Hello, I currently have three tables as described below and I need to get the following results when I run a query on them but can't figure out how the query should look. Basically, it will be a join on table A and B, but finding rows in C which are not found in that particular join. Table A...

I would like to connect into my AD via an ASP webpage, then given a specific group, list all of the members of the group. Is ASP capable of doing this? If so...how would I go about it? Thanks, Chris

Hello, I have data in the following format and I need a distinct count of users. I have a way to come up with the grouping, but making it distinct is causing me issues. ID | Device | Method | Username 1 | Alpha | X | smith 2 | Beta | X | smith 3 |...

I have listed data in a table and need to find the percentage of each occurance, so similar to a count, but instead of returning the total count, I need a percentage of the total. So... Column Type1 Type1 Type2 Type3 I need to have it return data in the form... Name | Percent Type1 |...

Hello, I would like to create a view of a table in a very specific manor...my table looks like the following IP | Code 127.0.0.1 | AA 127.0.0.2 | AA 127.0.0.3 | AB Then for my view, I would like it to look like... Code | IP AA | 127.0.0.1, 127.0.0.2 AB | 127.0.0.3 Does...