I cannot get the FormatCurrency function to work properly on my site, which is hosted on a server 2k3 box w/iis installed.It works just fine on my local iis machine, however w/out a glitch.
Here are the two side by side:
LOCAL MACHINE IIS over WINXP, Access Db, datatype=NUMBER, Format=CURRENCY HOST SERVER IIS over 2k3, Access Db, datatype=NUMBER, Format=CURRENCY Error Message that appears on host server... INTERNAL SERVER ERROR, error 500 Datatype mismatch....
I use <textarea> input more than one paragraph to the database, whose field type is set to "text". Then I retrieve it to display in <textarea>, which is OK, paragraph by paragraph, but not in the other tabs because of no <P> or <br> between each paragraph.
Is there any solution to display in other tabs than <textarea> paragraph by paragraph. Or do I have to change the database field type other than text? And which type is good in this case. Thanks for any idea.
I've created my database on MS Access and linke it to the web using ASP. I can display data from db. The problem I have now is when I display a data from db on ASP page I get the text as one block with no spaces or paragraphs format. Can anybody give me a hand of how to display my text as I entered. I stored text on field with memo type.
I am using RTF files to store a template which has certain tags which should be replaced with content with ASP.I can use the VBScript function replace to do this substitution but is it possible to merge the pages in one file with those in another from ASP?Is there also an easy way to print out the result?
Is it possible to store html tags in a database field so that when data is retrieved from this field the formating is retained? For example I have an address field in my database, which I return using:
<p><%=(rsType.Fields.Item("DAT_Address").Value)%>
However they are times where I may want to have my city, state etc on seperate lines by using <br>, but right now if I store a <br> in my database it does not affect the formating of my displayed address.
I need a user to follow a format. For example entering a date. I need the user to enter a date in this format MM/DD/YY. How do I check to see if they followed that format?
I need the user to enter a currency amount without the "$" sign. How do I check to see if the Request.Form("price") value has a "$" sign in it? I guess I need to know how to parse a string in ASP.
I have a text file containing korean fonts, i saved it as a unicode format in notepad. i tried to load it in asp using #include file, i get an "UNICODE ASP files are not supported" ....
Is anyone having problems with formatting text using the ASPPDF component? I am having problems when it fills in the pdf form from data entered through a form. For some reason it doesn't allow me to format the text or resize it...
i have several fields in the database that the format is number. then, i have a report page that allow user to open it the ms excel. my problem is, when all data transfered to ms excel, all data that is in number format, they are located at the right of the cells and there is 1 data named noIC, suppose this data is a 12 digits number but in the ms excel, it became something like this 780945+E12....
to solve this problem, i have to change the cell's format everytime all data have been transferred to ms excel. i have to set to left indent for all fields that contain numbers and for the noIC i have to set from General to Number.
Is this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I am trying to develop a little site for myself an co-workers to enter our march madness bracket picks. With the tiny little bit of knowledge and some cutting and pasting I have created a mess that sort of works.
I have a JS form that users can enter all of their own picks. However, when the picks are entered into my DB the only appear as numbers. There is an area in the code that refers team #'s but it doesnt quite match what I get in my dB for instance - kentucky should be 1 and it shows up as 0.
Here is the code - if anyone can throw some tips my way I would really appreciate it. I have edited out the actual Javascript and the .css styles and other things that arent applicable (I hope) for easier reading. Code:
I'm running ASP on IIS 5.1 on Windows XP, the same thing works on Windows 98 with PWS.
The function below stuck the IIS - draws only frame with nothing inside and wait for infinite. All other requests to IIS are stuck. I presume that it is some permission thing, but what? Is there some log or something that I can check? Code:
We have a server with an Intranet, it handle the contract forms we want to send the contracts forms by email but the emails are stuck on the queue folder. we are running with win 2000 server, SMTP, IIS, creating the pages with ASP.
i want to have alert for my delete process. but I have no idea how to call my function in this case. this is the text.
<a href="padamlaporan.asp?idl=<%=id_laporan%>&i=<%=request("i")%>">Padam Laporan</a> i want to call this function.
function padambutirlaporan(){ if (confirm('Adakah anda pasti untuk padam laporan ini?')){ document.location.href = "padambutirlaporan.asp?idl=<%=id_laporan%>&i=<%=request("i")%>";
For example: The text to be searched is the following:
Text 1: Hello world! what a nice day today. But I like to sit in front of computer and doing some web design. Now I have encountered some technical problems and would like to get some helps from the experts.
Text 2:
I like fishing.
Text 3: Baseball season is over.
Text 4: The winter snow storm is coming.
Search Keyword: snow. Search result is Text 4
Search Keyword: I Search result is Text1 and Text2
At the end, the key word should highlighted with a different color in the paragraph.
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
I have this problem in controlling a the text in a Text Area. How can I do that for example the field size is 200, when it reaches 50 it automatically goes to the next line. Bcoz im having problem when viewing it in my report, it continuesly views in a strieght line and im having problem in printing.
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:
I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.