|
Hi,All,
Export Method:
-------------------------------------------------------------------------
strFileNameExport = "Results"
Response.Clear()
Response.Buffer = True
Response.ContentType ="application/vnd.ms-excel" 'application/msword
Response.Addheader "Content-Disposition", "attachment;Filename=" &
strFileNameExport & ".xls"
Response.Charset = "GB2312"
Response.Codepage = "936"
tblHeader = ""
tblFooter = ""
Response.Write tblHeader & strContent & tblFooter
---------------------------------------------------------------------
I used this code to export the content of table to Excel File. But when i
opened the Excel file, sometime the words of the content would be showed as
"confused" words. But so strange the same table (same content), sometimes
would be "confused". And sometimes it would be showed normally. It's
randomly between "confused" words and normally words.
And I had tried to change all Charset and Codepage setting of all pages. But
same result.
Seems this problem not related with Charset and Codepage setting.
(All words showed "confused" is Chinese words. And english words all are
normally. Randomly showed this error sympton in Excel file.)
Environment: ASP,SQL2K,WIN2003.
--
Benny Ng
|
|
|
|
|
well, does any one know how to put a small java script code (about 10 lines) into a c code script?
what i am doing is creating a web page (by putting html in the c code)
and it works but now i want to add java in and it does not work.
i thought it was like this:
strcat( buffer,
"It is now "
"<!--"
"var currentTime = new Date()"
"var day = currentTime.getDate()"
"var month = currentTime.getMonth()"
"var year = currentTime.getFullYear()"
"document.write(day + / + month + / + year)"
"" );
any suggestions?
thanks
***
|
|
|
|
|
Doesn't Javascript need semi-colons to terminate statements. Your string reads:
It is now <script language=javascript><!--var currentTime = new Date()var day = currentTime.getDate()var month = currentTime.getMonth()var year = currentTime.getFullYear()document.write(day + / + month + / + year)</script>
The javascript parser is probably getting confused because all the statements run into each other. Also, you didn't terminate the comment that is there so that browsers that don't support javascript can ignore the javascript code.
|
|
|
|
|
On one of our websites I have some error checking setup and have been getting errors today as googlebot has been visiting the site. The error is occuring because of a missing querystring parameter. At first I thought some of the links may not have been updated as this parameter was added recently but I've checked the site and can't find any old links.
Does anyone know where googlebot could be getting these old links from or could it be googlebot is removing the parameter. The parameter in question is named sid and a colleague suggested googlebot might be seeing it as a session id parameter and removing it from the url.
SuzyB
If I had a better memory I would remember more.
|
|
|
|
|
hi Suzy,
you can read about googlebot here[^] If nothing on that page helps, there is support email... In that case, don't forget to post answer here! 
Can't it be:
Why is Googlebot trying to download incorrect links from my server? Or from a server that doesn't exist?
It is a property of the web that many links will be broken or outdated at any given time. Whenever anyone types a link incorrectly that points to your site, or fails to update their pages to reflect changes in your server, Googlebot will try to download an incorrect link from your site. Also, this is why you may get hits on a machine that is not even a web server.
If I understand correctly somebody can link to your site with old link... and when site linking to your site is crawled, googlebot follows bad link.
best regards,
David 'DNH' Nohejl
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
|
|
It turns out its not just googlebot. When I got in this morning I had some more error notification emails. This time it was msnbot that was looking at the site.
SuzyB
If I had a better memory I would remember more.
|
|
|
|
|
hmmm... it might be that the search engines are "throwing away" the query, because it is that... a query string.
http://www.mysite.com/page.asp?id=12
becomes
http://www.mysite.com/page.asp
because the search engine wants the actual page, not some arb query...
personally, i think that using a query to specify a page is wrong. each page in one's site should be a physical page, and one should use post variables rather than get variables to transfer data between pages. it's safer and more "invisible" - especially when you're using some sort of online form.
--
Raoul Snyman
Saturn Laboratories
e-mail: raoul.snyman@saturnlaboratories.co.za
web: http://www.saturnlaboratories.co.za/
blog: http://blog.saturnlaboratories.co.za/
linux user: #333298
|
|
|
|
|
Hi Guys,
I am really struggling, i am trying to save images to a database to display them on a web site, The problem being i don't have a CLUE. I have searched the web over and over and can't find a simple how to. Can any body help.
I need to know how to store images in a database (what do you save them as?)
How to retrieve them from the database, and display them on a page.
Any examples would be great.
Cheers
Mav
|
|
|
|
|
|
depends on the database server you're using. for instance, interbase and it's open source derivative, firebird, have a "blob" type [Binary Large OBject] which can save almost anything. mysql and postgresql have that too. ms sql server has an "image" type.
exactly how you go about storing them and retrieving them is dependant on the database server. that's where you need to read up a bit...
hth!
--
Raoul Snyman
Saturn Laboratories
e-mail: raoul.snyman@saturnlaboratories.co.za
web: http://www.saturnlaboratories.co.za/
blog: http://blog.saturnlaboratories.co.za/
linux user: #333298
|
|
|
|
|
Hi all
I am trying to submit asp form info and save it automatically as a .doc.
I know there is code for doctype = application/word or something to that effect but I want it to save it without having a dialog box come up and ask the user where to save it.
any code examples would be great
thanks
|
|
|
|
|
You could look into VBScripting Client Side Function that then opens up Word on the client machine.
Starting with
<br />
<br />
Set objWord = CreateObject("Word.Application")<br />
objWord.Visible = true<br />
I can't find a code example, but if you can find any VBA book, it will give you a ton of examples of how to VBScript Word.
The only other thing you will need to consider is that your website will need to be a trusted site in the client's InternetExplorer. Otherwise the user will need to intervene in order to get the document saved (security).
I know it's not a code example, but hopefully it will be a good starting point.
Torin Blair
'In the immortal words of Socrates - "I drank what?".'
|
|
|
|
|
How do I create a COM object with clientside javascript?
var loFID = new ActiveXObject("xxxx.xxxxx");
Is givnig me an error
Automation server could not create object.
Am I doing something wrong?
Thanks
|
|
|
|
|
Which COM component are you using on which operating systems? If the ActiveXObject is depracated, then it might not exist on the Client operating systems you are targeting.
Torin Blair
'In the immortal words of Socrates - "I drank what?".'
|
|
|
|
|
I am using Windows 2000. My COM object is part of our software and I am using the ProgId.
Thanks for the help.
|
|
|
|
|
You may also check browser security settings. I supose you use IE; there is Tools->Internet Options ->Security tab -> Custom Level and there allow Script ActiveX Control... (try some).
One more thing that come in my mind is to set right for user/Com component: Start->Control Panel->Administrative Tools-> Component Services.
hope it helps,
David 'DNH' Nohejl
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
|
I am working on a Cold Fusion project, and would like to design a few objects into the pages. I have seen thermometers and other gauges at some web sites that look really good. WeatherBug has some of these. How can I find out some information on how to design special objects like this myself?
Jerry
|
|
|
|
|
If you are looking to use .NET then I would recommend starting by looking at the ASP Reports example project on www.asp.net as a good jumping off point for building graphics using GDI+ for use in web applications.
Torin Blair
'In the immortal words of Socrates - "I drank what?".'
|
|
|
|
|
I need to know how a java applet read data continously from server? Like some applet has funtional like a webcam.
Thanks.
|
|
|
|
|
Working with a big web project, you might find your self working with many pages. What will you do when you have to add many files with some content. Example: You have a sales product A and sales product B page, and you want to add some validation on both files. Is there an easy way for that? I`m trying to make an application for this.
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
hi,
Yulianto AKA goodmast3r wrote:
Working with a big web project
What technology is used? ASP.NET, PHP ... ?
Sorry if I misunderstood your problem, bt I think you want to reuse some parts of pages, right?
You may look at Custom or User Controls in ASP.NET. Just make little search in CP articles, MSDN or using google... Not sure how is it with PHP etc, bt concept should remain the same.
does it help a little?
best regards,
David
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
|
I`m using ASP. I gave the wrong example. What I meant was there are two page, sales for spare part and sales for tool, and I want to add validation on both files. With only two page it`s easy, you can open those files and copy paste the function. What if I have 5 pages or more, is there an easy way then opening each file and paste the function to each file?
<hr><h5><italic>Work hard and a bit of luck is the key to success. </h5></italic>You don`t need to be genius, to be rich.
|
|
|
|
|
hi,
Yulianto AKA goodmast3r wrote:
What if I have 5 pages or more, is there an easy way then opening each file and paste the function to each file?
I am afraid you must be more specific.
If you mean JS function, see this thread[^]
If you mean ASP function, there must be something like include...Yes it is.[^]
Yulianto AKA goodmast3r wrote:
What if I have 5 pages or more, is there an easy way then opening each file and paste the function to each file?
hmm  Are you talking about IDE-level thing? Hardly. (maybe except some obscure use of Search in files & replace in Visual Studio)
hope it helps.
If not, ask for moretm
David
Never forget: "Stay kul and happy" (I.A.)
|
|
|
|
|
dnh wrote:
hmm Are you talking about IDE-level thing? Hardly. (maybe except some obscure use of Search in files & replace in Visual Studio)
Just like that, but not Search or replace, but insert, so that we can insert JS function in many files. I`ve been making an application for that. But got many problem. I`m still looking for a RichEditView article in CP.
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
