Search results for query: *

Actually I figured it out. I think what I will do is insted of taking the items and one by one trying to do an insert which is not working anyways. I think I will place the items into an array and then put them into a hidden textbox and placing a comma between each one at the same time which...

Yea I checked to see if it works and it gave me the following error. This error occured when I tried to insert more than the one row. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The...

hmckillop, thank you for the wonderful reply. I did not know what SCOPE_IDENTITY() was and thus I will look into that and try to complete my task. What I am actually doing is writing a C# application and this part of it is taking a table and inserting it into another. By doing this I have tried...

Just a quick question, I am trying to insert after another but I want them to be on the same rows. For Example, Insert into test (FILECODE) select filecode from tester Insert into test (KEYCODE) select keycode from tester When I do the above I get this... FILECODE KEYCODE a a a a B...

Thanks a bunch! When I get a chance I will take a look at it and get back with you, Ron "Success consists of going from failure to failure without loss of enthusiasm." Winston Churchill~

Can anyone tell me what Im doing wrong here? Id like to take out every other '\n'. Also the "count" is the number of lines in the richtextbox. for (int i=0;i<=count;i++) { char t = '\n'; if (i % 2 == 0) { richTextBox1.Text.IndexOf(t,i,1); } } "Success consists of going from failure to...

Ok I figured it out by googling it for awhile... http://dotnet.mvps.org/dotnet/faqs/?id=controlsmissingtextbug&lang=en Thanks guys. "Success consists of going from failure to failure without loss of enthusiasm." Winston Churchill~

I guess no one else has had these occurences? "Success consists of going from failure to failure without loss of enthusiasm." Winston Churchill~

There are somtimes in which I will run into a message box not showing the text and today I created a test program with a listbox and added items to it and could not see them, yet I was definately adding them because the scroll bar would shrink. Whats going on? I sent my test program to another...

I figured it out.. it was pulling -1 radius fields and placed the null in there so I just added "where radius > '-1'" in the where clause Thanks for all the responses. "Success consists of going from failure to failure without loss of enthusiasm." Winston Churchill~

i only posted a little fragment of the code so i could not do that. "Success consists of going from failure to failure without loss of enthusiasm." Winston Churchill~

let me rephrase. (SELECT top 100 percent 'radius' = case when cast(t2.radius as numeric(10,0)) between 0 and 100 then '0 to 100' else null end results- radius field field field NULL 10004753 0 0 I dont want this to show in my results I already have tried adding radius is not...

Id like every row with the NULL in it to not show up in the results. Thanks "Success consists of going from failure to failure without loss of enthusiasm." Winston Churchill~

If you were to want the ELSE [return value] to not show up at all what would you do? any tips? CASE [expression] WHEN [value | Boolean expression] THEN [return value] [ELSE [return value]] END "Success consists of going from failure to failure without loss of enthusiasm." Winston...

I have a file with multiple lines and id like to remove every other lines '/n' for example change this- Firstname Lastname City State Address Homephone Workphone Josh Luis Deland OK 921 Golf Drive 7778888 9991234 to this- Firstname Lastname City State Address Homephone Workphone Josh Luis...

I have got a dts which runs and creates a table with a filename and a date stamp but it bombs everytime it goes to create another. If I run it 1 time it works fine. If I delete the xls file and try to run it again it wants me to go into the data pump and click "Create Table". any clues how to...

Yea that works.

Nope it has a password. My console program goes to the site and opens a page. There is then a little toolbar on the page with an Excel icon which I have to click to download the spreadsheet. I could automate it using sendkey() but I cannot get to the button via TAB so i therfore must click it...

Yes but you cannot get to it by tabing over and hitting enter.

um? let me explain... I mean lets say I wanted to click a button on a website, and i want a console program to do this automatically.