Search results for query: *

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

sorry I know how to do the insert it is changing the way it inserts the data is what I want to do as you can see the file is laid out like: ICR,X3,51,2,10:37:40,14/10/2008 1,2,137.00 3,1,8.00 I want to insert the 137.00 into column gross_sales and 8.00 into net_sales but if I run the insert...

Morning, I have some txt files in the format of: ICR,X3,51,2,10:37:40,14/10/2008 1,2,137.00 3,1,8.00 Here is the problem: I have my table laid out as net_sales | gross_sales I want to ignore the first row which I do with FIRSTROW = 2, and insert the other two rows into the columns but...

Afternoon, I am finding it difficult to send an email via a asp.net project I am working on. I have posted the code I am using below Dim mMailServer As String Dim mTo As String Dim mFrom As String Dim mMsg As String Dim mSubject As String Dim...

Dim strSQL As String strSQL = "UPDATE tblauth SET " strSQL = strSQL & "email='" & txtEmail.Text & "'," strSQL = strSQL & "telephone='" & txtTelephone.Text & "'," strSQL = strSQL & "mobile='" & txtMobile.Text & "'" strSQL = strSQL & " WHERE username='" & Session("UserName") & "'"...

getting there lol, there is a line in there which is 23=Demo Merchant so it is picking up that then just the 3= how can I tell it just to get the 3= and not anything else like 23= Demo Merchant the problem is the 3= is always on different lines too so I cannot just tell it to split the data...