Search results for query: *

Hi All, I'm trying to find a way to declare a class in a code behind page that will allow me to use it within different functions and procedures without having to declare it each time. Another question while I'm asking, when I declare the class, I pass it a userID which is stored as a session...

Hi All, I am about to write a Stored Procedure and thought i would ask if anyone had any advice. The query is to take values from a default table, and add them to another "live" table. Every monday an "A" shift is to take place. - From the default table I want to take the that shift and make...

Hi All, I was wondering if anyone knows how, it at all, a guid can be removed from a table. Just the existing value, not the row. I have a table with a guid column that relates to another table and its value is a guid. I want to set the guid to nothing if it is deleted from the other table...

Hi All, I am trying to find a way to use a stored procedure to filter out the records i do not want rather than in my program. I have a list of shifts that are linked to a piece of equiptment, which has an equiptmentID. I have a table that links workerID's to what equiptment they can work...

Hi All, I am have been looking into why a script of mine does not work, when I came across i very strange error. My server does not like the day 29th March 2004. Then when i dig a little deeper, it turns out it does not like the last Sunday of March in any year. Although I am able to format...

Hi All, I'm very new to PHP, I'm an ASP guy traditionally. I have come across a very strange problem when extracting data from a MySQL DB. It seems to "skip" bits of data. I have used the following code: echo "Serial Number: $row[SerialNo] echo "Repair Type: &quot...

Hi all. I'm looking for the genius of all genius's! I have wrtitten an DLL in VB to access a MS Word installation on a server to use its thesaurus components. Why i hear you ask, well becuase the client insists it is needed! Well, i have it working on my test server, and i also have it...

In ASP, an include file could be used to hold the the database connection string, meaning changing it in the one file would mean the entire site would connect differently. is there a way to do this in ASP.NET? At the moment i use VS.NET to create a connection, from which i drag the data onto...

Hi all, I am trying to create a SP that will insert some data into a table, where the table name is provided as a varialbe. ALTER PROCEDURE InsertStudentAttendance ( @Date datetime, @tableName varchar(15) ) as DECLARE @myStr varchar(500) declare @CDATE varchar(25) set @CDATE =...

In the web listbox, there isa command to add an item with a seperate value, listbox1.item.add(new listitem(VALUE,"TEXT")) But I can not find anything like it in the windows form listbox. It is possible to do this through databinding, but i am not using a dataset, i want to add the...

Hi Guys, Some advice please, What do you think is the best way to find winners from a database? Jackpot is easy, but matching 3, 4, 5 and 5 + Bonus Ball had got me stumped. Its out of 49 balls. Is there an easy way to do it, or is it just gonna be a very long select statement? John.

Hi guys, I want to insert records into a table from a csv file. the file currently hold 700+ records, and there are 2 new records added each week, but they need to entered seperatly into the database on seperate days. I have seen the bulk insert and concidered deleting all the records and...

I am trying to insert a record into a table that was created on the fly. The table is created with errors, and when i check it, all the columns are of the correct data types. I am using the code ALTER PROCEDURE InsertStudenttoClass ( @tableName varchar(10), @StudentID int ) AS DECLARE @myStr...

Hi, Is there a way to remove empty spaces held by the database? I am using an SQL statement: SELECT LecturerTitle + ' ' + LecturerInitial + ', ' + LecturerSurname As LecturerName to select a name out of a database. but the initial field is two characters long, do when it is extracted it...