Recent content by UKmedia

I have developed an application that uses crystal reports for it's reporting but when I install this on a client machine it brings up a crystal error. Are there any crystal report run time files I can install on the client machine? Also how do I create an install package for a program that I...

Morning All, I have a problem with our new 2003 IIS 6 webserver. I can see normal html webpages but when I place my ASPX pages up it reports that it "could not load type '_default' the aspx project is using framework 2.0 and the IIS server has framework 2.0 on too. I have all my .aspx & .vb...

that worked cheers, It was also down to me trying to enter in a text item into a number field too.

i have done this but cannot see where.

Dim strSQL As String 'Update Existing strSQL = "UPDATE cashier SET FullName = '" & txtName.Text & "', Address = '" & txtAddress.Text & "', Telephone = '" & txtContact.Text & "', Age = '" & txtAge.Text & "', NI = '" & txtNI.Text & "', EContact = '" & txtEContact.Text & "', EName...

how can I insert the current date into my insert query in script?

oh yeah how silly of me, I think i need a break from this application coding in vb.net and asp.net then SQL is not a good idea your brain goes. cheers

no that still reports that there are more columns than values to insert. this is my code. USE rac drop table import_temp CREATE TABLE import_temp ([col1] [float] NULL, [col2] [float] NULL, [col3] [float] NULL) BULK INSERT import_temp FROM 'C:\test\tilldata\2100200850.csv' WITH...

k i understand what you mean, but how can I set a default value of say null or 0 but still see if there is a value in my select query if there is not then just insert the default value. declare @f5 float set @f1 = (select col3 from import_temp where col1 = 1) UKmedia productions...

I have the following script: drop table import_temp CREATE TABLE import_temp ([col1] [float] NULL, [col2] [float] NULL, [col3] [float] NULL) BULK INSERT import_temp FROM 'C:\test\tilldata\2100200850.csv' WITH (FIELDTERMINATOR = ',', FIRSTROW = 2) declare @f1 float declare @f2 float...

it's ok i went with the listview in the end. UKmedia productions http://www.uk-media.com

Morning, I have a function that gets all the file names within a dolder and lists this to a listbox. I already have the function that opens a file and then reformats the date in the file and then saves it in another file format for me. But as there are many files in the folder I need to do...

worked it out MyReader.ReadLine.Remove(2) UKmedia productions http://www.uk-media.com

I have found this that allows me to read the file and I am outputting the response to a textbox but I have 1 question How can I ignore the first row as I don't want to read that row? Using MyReader As New _ Microsoft.VisualBasic.FileIO.TextFieldParser("C:\test\file50_old.txt")...

Evening All, Does anyone have any idea on how I can format a txt file that is already populated with text. The file comes as: ICR,Z1,50,1,14:55:07,15/10/2008 28,10.00,459.00 29,14.00,459.00 30,16.00,512.00 and I want it to just be one line ICR,Z1,50,1,14:55:07,15/10/2008...