Search results for query: *

I changed how the validation would work. Instead I added a small javascript to validate the field when the submit button is use. Here is the code, in cas it can help someone: <script language="JavaScript"> function ValidateEmailForEBill() { if (document.getElementById("optBill2").checked)...

Here is what I tried: <input name="optBill" type="radio" id="optBill" onmouseup="<%Contact_Email.Text = "YourEmailGoesHere"%>" value= "PAPER" <%if(AdorRec.FieldValue("Billing_Type", null)=="PAPER") {Response.Write("checked");}else{Response.Write("");}%> />Through Email (EBill) The Idea is...

Hi How can i validate a textbox based on a radio button. Let says I have two radio buttons in a form : Invoice Paper and E-Bill If the user select E-Bill I want to make sure the email textbox is not empty, otherwise it does not matter. I need to do that on the submit button. I am working with...

I found the issue. I am working on a Development server that was installed with FRENCH_CI_AS instead of SQL_LATIN_GENERAL_CP1_CI_AS. I tested my code on another SQL server and it is working... I should have though of that before thanks George... here is a star for you! Mal'chik [bigglasses]

I just tried your code and the spaces are still being dropped, but that helps me. I now suspect that there is a settings in the SQL itself, i will take a closer look at the server configuration. thanks! Mal'chik [bigglasses]

It was my first guess, but my variable is already a CHAR. Mal'chik [bigglasses]

Hi I use a SP to create a text file using FSO. I need to add extra spaces at the end of each line. When I look in the file, the extra spaces are not there. For example: SET @Data = 'ABC' SET @Data = @Data + SPACE(5) EXECUTE @RetCode = sp_OAMethod @FileHandle,'WRITELINE', NULL, @Data it will...

Thanks for the info. You are right about the sp_, my mistake Mal'chik [bigglasses]

Hi, I am trying to save images in an sql table and then use it on a CrystalReport. Here is the code I am using. The system gives me an error : Incorrect syntax near 'sp_sp_InsertImage' I double checked my parameters and field. I am pretty sure it is the way I call the SP... could anyone help...

Hi, I have a SP that takes the content of a table and export it in a text file using FSO. I noticed that the variable is trimmed by the WRITELINE method. For example if I have a value ABC followed by 5 spaces, the spaces are dropped in the file. The only way to keep the spaces is to add a bogus...

Hi I use to be able to do summary fileds (sum, count...) in the page footer in Crystal Report 10. I try to do the same a VB.net program, and the only place the integrated Crystal Report let me put summaries are in the group footers or the report footer... How can I set a sum field in the page...

Hi, I need to show a description of an operation in a label while an SQL DTS and stored proc are launched. The SQL part works fine, but my label do not show the text. In VB6 this problem can be worked around by using REFRESH of DOEVENTS. How can I reach the same in .NET. Below is part of the...

Hi, I created a DTS in SQL that gets an Excel file and imports it in a table. The file source path and name may change, since multiple users will upload it through an Intranet site. I searched a way to dynamically set the source and filename using a Gloabal variable in the DTS and sevral...

Hi, I need some help to create a multi-language 'sitemap-menu' for my Intranet site. How can I change the menu lable based on the language selection (session variable). Here is my Sitemap for the site (in French). I know i cannot have two node pointing to the same page... so i am not sure how...

ups! I am so sorry, I figured that the parameters order from the report do not matter, since i explicitly name the parameters from the ASP.net page. I had a bug in my code, i forgot to create a new instance of ParameterDiscreteValue for each param duh! Mal'chik [bigglasses]

I found actually this: Dim cnnInfo As New ConnectionInfo With cnnInfo .ServerName = <put the SQL Server name> .DatabaseName = <put the DB Name> .UserID = <put the username> .Password = <put the password> End With For Each cnInfo As TableLogOnInfo In crView.LogOnInfo...

Hi, I wonder if it is possible to change the parameter order from the Report to reflect any changes made in the stored proc. I have a report based on a stored proc using 3 parameters for example sp_MySp A, B, C I created the report. But now I added an extra parameters to the stored proc...

Is it possible to embed the credentials for the LogOn in the report itself? I am using an SQL Login and Password to connect the SQL server, but this report will reside on our Intranet, so I would like to embed the credential so the user can open the report without having to input the password...

Thans Qamgine.... it works wonder! It would have take me a long time to figure that one out... here's a star Mal'chik [bigglasses]