Recent content by Malchik

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