Search results for query: *

How can I set this into a declared variable so I can use this in an IN Statement DELCARE @CustList AS varchar(50) SET @CustList = '1','2','3','4' SELECT * from tblCustomer where CustNumb IN (@CustList)

Ya I am confused I think this might not work either. Maybe I just need to use straight javascript code. Calling on the exit of a textbox a function that prompts a confirm and if the user clicks yes then fill the txtbox(x).Text with the same values

This is what I have so far in my code behind but its not working: Dim sb As New StringBuilder sb.Append("<script language=javascript>") sb.Append("if (confirm('Your query returned over 1000 records. Do you want to proceed?')") sb.Append("{")...

How do I call javascript function called "messageuser" from the change event of a text box in ASP.Net

Thanks SQLSister

Hello all. When Selecting from the Inserted table on a trigger wont there always be just one record? UPDATE Customer Set MailSend = 1 where CustNumb = (SELECT CustNumb FROM INSERTED) This is on the insert of a new record. Wont I only have one value for this each time? Somehow I am...

I needed the autopostback = true thats what I really needed. It seems to be working now. One last question I need to prompt the user if they want to roll the totals into the other textboxes. The routine is firing now correctly. How do I prompt the user with a Yes No dialog and then run my...

How would I do that? I have the textbox as Runat="server".

Can I call a VB Code Behind routine from within the javascript?

Hello all. I have 12 textboxes on a form where currently I have a client control validator for each checking if the value is currency. How can I also call a sub routine either on the change or exit of the textbox to call a Total Sub Routine which adds up the textboxes and places it into a...

I got it to work. Do you happen to know how I can on the update of a textbox or the lost focus call a Total routine in my code behind? I already have a validator on the box checking for currency. But now I need to call a Totl routine on each box.

Getting this error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

I need to total textboxes going across. However I do not want to place a "0" in the textbox itself. Can I somehow default in my code that value to 0 without having to complete IF statements. Right now it goes (Cdbl(textbox1.text) + CDbl(textbox2.text).ToString But one of the values could be...

I have a datagrid where I have a "DataFormatString="{0:#,##0.00}" as the format of the column. I am using CDbl to total columns with a .ToString at the end to fill a textbox. How can I make this the same format so lets say 10000 comes up 10000.00 thanks all.

Is there a way to force my dropdown list to open down on page. When I open the box the values all flow up over the page then going down.

Hello all. I have multiple text boxes that are going to have the user typing in currency values like 5.25. How can I have one validator to handle these multiple textboxes? I don't want to have to use a validator control for each textbox. Thanks all

Hello all. I am trying to recreate an access query in SQL. The query below where you see the HAVING clause is causing less records to come out then without it, however there is no Null values in that table "Bud_State Allocation" that is referenced in the Having clause but its still returning...

Thanks Patty. Perfect thanks for the help on that.

Hi all. Why in SQL 2K query analyzer when I run this: SELECT 2000/8000 AS TEST I am getting 0 back instead of 0.25?

Might be more than one space possibly.