Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Conn.Open() --> What is a better programming practice?
In my openion the second method is more professinal and i am always used it. Finish your loop and then close the connection at the end, no need to do more work.- Ibtisam
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Blank Subreport...
1) Open your subreport and in the details section where you displaying all the fields. 2) Choose one of the fields that you want to show it Let's say for example the field name is "EMP_NAME". Make sure that this "EMP_NAME" field will not have any data when you want...- Ibtisam
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Blank Subreport...
You have to put in subreport "Data is not Avaliable" as a text and suppress this text when there is data, if there is no data do not suppress it. if you want in more details i will send it to you with scripts. Ibtisam.- Ibtisam
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Large Text - What type of field
Hi Kinl, In ASP you can not have double quotation inside double quotation. So, what you will get if you try this code? the Code: "EXEC spPR_ReleaseInsert [' & TRIM(Request.Form("info")) & '], [' & TRIM(Request.Form("headline")) & '], 1" If it is still not...- Ibtisam
- Post #17
- Forum: Microsoft SQL Server: Programming
-
parameter hard coded in SQL statement?
To hardcode the parameter in SQL statment you have to write it like this: Table.FieldName = '{?ParameterName}' I thing you miss the sigle quote.- Ibtisam
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Active Data Driver - ASP Project
I faced the same situation. I was trying to view my report through ASP page and connecting to sql server. It works fine, with using the activeX controls. I think the "type mismatch" error you got because the parameter type you send to the report is not of the same type that used in...- Ibtisam
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
