Hello Team I have to export values from asp file to excel file, but the value in which are coming in excel contains blank space , is there any method that we...
Shawn: Yes, I am accessing it through an ".aspx" page. It is not within another control. The ".ascx" file is simply html code. Listed below is the ".ascx"...
Need more input, like #5. VBScript, if that's what you're using, has a trim() function that you can use before putting the data in Excel. Ray at work ... ...
Costanzo, Ray
rcostanzo@...
Oct 1, 2003 12:47 pm
7256
Dan: I would assume at a minimum 2000, as I think that is needed for .Net Thanks Andy ... What OS is the server running? Dan ...
Dear Rahul: To put an excel formula in an asp page is the same way that you can put any other formula. Except that you have have to have the necessary...
How exactly is the & sign affecting your query? Since you're delimiting with ', it shouldn't matter. Your query looks like this, correct? sSQL = "SELECT...
That's it. You need to change the crlf to vbcrlf though. Sometimes you need the other ways too. Instead of vbcrlf, sometimes you need chr(13), too. Rick...
You probably mean vbCrLf. Make sure you only do these replaces when you are displaying your data. Don't do this before inserting the data into a database or...
hv u got the solution? i got into the same situation and got an utility (exe) which does this fn. just wanna check how u got around here. ILyas _____ From:...
Dear Friend: There is nothing wrong with your SQL Varible below. You may have forgotten how to use it in ASP. This is how I use it: First declare the...
I'm trying to select all records from an access (ugh) database. There are records in there but the query returns nothing. Do I need to convert the date?...
For Access, you must delimit dates with #, if it's a date/time column. when = "#" & Request.Querystring("when") & "#" Ray at work ... ...
Costanzo, Ray
rcostanzo@...
Oct 3, 2003 7:17 pm
7272
Ray, thanks again. You're the best. One question, though... do you actually get any work done at work?! You're always the first to reply! lol! Thanks again! ...
I don't start working until everyone else has left for the day and it quiets down enough to get some stuff done. :] This is especially true when there is a...
Costanzo, Ray
rcostanzo@...
Oct 3, 2003 7:22 pm
7274
I SO need to move to a sql provider... I know you cant do SELECT COUNT (DISTICT xyz)in access... is there another way to do it? Thanks! Rick...
SELECT COUNT(xyz) FROM table WHERE xyz IN ( SELECT DISTINCT(xyz) FROM table ) I believe that's the syntax. Rick Rose www.howlingwolfcomputers.com Custom Made...
Better chair, better computer, don't have to wear a tie, can drink beers, smoke cigarettes, curse, or do whatever else I want! I love home! :] Ray at home...
Dear friends, Of late I am getting to know the usage of Dreamweaver MX. It is really wonderful one. The features in it are so easy. I used to use to host only....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
