When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
View RepliesI'd like to write a bunch of queries from a SQL Server 2000 database in my ASP page and have a way of copying this information into an excel workbook in specific cells. Writing the queries isn't the problem, I just need to place it in a file in different specific cells.
Is there a way to do this? Do you have to use VBA code or something? the *.iqy technique isn't going to work, cause I have to place the data in a sepcific excel file, in sepcific cells. I am not sure how to do this or if it's possibly, if anyone has any
ideas on where to start or find some sample code I'd REALLY appreciate it.
I would like to change an ASP module using ASP and an ASA routine to dot NET to take advantage of some dot NET features. Do I simply change the ASP and ASA extension to aspx and asax? I tried this and got errors.
View Replies View RelatedI have a menu system that has nodes that can be opened or closed. In an
effort to make my code more manageable, I programmed a little widget tonight
that keeps track of the open/active item and automatically builds
querystrings for my redirect URLS. The code for this follows. It defines an
ASP Dictionary object, and key/value pairs for each, and builds appropriate
querystrings based on comparison with a status variable.
The way it works for now is I manually declare and re-declare a variable
("CurrentContentClass") in places throughout the code where there is a new
menu item. I embed this same block of code repeatedly through my
application, one for each menu node. This is a really stupid approach, and
I'm sure there's a better way.
Better would be to create a single function into which you could feed
parameters and get output. I've used lots of functions in my auspicious
career in ASP, but I've never created one myself.
Can anyone suggest tutorials or approaches such that I can learn how to
create my own functions? Any guidance based on what's below? Code:
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
View Replies View RelatedI have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
The SQL statement is as follows: Code:
I have a password-protected area on my site. I'm not using any server
authentication methods: Instead I prompt the user for a username and
password using an HTML form and check these against a database of
registered users.
I was thinking that this page should be returning a HTTP status code of
"401 Unauthorized" instead of its current "200 OK". My reasoning being
that this would let search engines know what's going on when they
request a protected page and get redirected to the "Access Denied"
page.
I experimented with adding response.status = "401 Unauthorized" to the
"denied" page, but now it displays a (Windows/IE) username & password
prompt instead. The HTTP sniffer shows that the www-authenticate field
is set to "Basic".
My question: How can I indicate to the search engines that the page it
is requesting requires authentication, yet have it not display the
login/password dialog box?
Currently I am having an ASP page to store data into access database, I would like to convert my database into microsoft excel format due to licensing problem, I never deal with excel databse in asp programming before, appreciated if some expert can show or guide me thru this.Tks a lot.
what are the code that I need to change in my asp code to link to excel file instead of access db.
I have just changed host and I need to change my Server.MapPath to comply with my new host db folder . Currently I have my path set to
Server.MapPath("db/access.mdb")
but I need to move it back up a few folders so it is above the "www" folder in the new hosts specified db folder. How do I achieve this?
how I could change the value of a server variable when the user clicks a button. The asp page displays a report using server side vbscript, and I have added an 'export' button that will copy the report to a file. I need this button to change a boolean so that the page will re-run, writing the report to the file instead of the screen.
View Replies View RelatedWhen I upload the .asp file into the server, it adds &nbps; into two of the columns of my table.
I have deleted the server's copy several times, but all the time the file gets corrupted.
I have been using HTML-Kit, Front Page and Note Pad to view my code. This error only appears in Front Page & sometimes in Note Pad, but no in HTML-Kit.
Any ideas how can I solve it?
I have a total cost listed on my page, followed by 3 radio buttons named postage. What i would like is for the total price that is displayed on the page to change depending on radio button that is clicked e.g. US Rate, UK Rate, Eur Rate. Im not sure how to do this without sending submitting the form to a new page which is not possible given this situation.
View Replies View RelatedI have one comment before I begin. An ASP Forum site using PHP, doh.
All of my pages begin like this:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html><head><!--#include file="header.htm"-->
<link href="css.css" rel="stylesheet" type="text/css">
<title>Some page</title></head>
I saw a friend change all of the titles using a code that looked something like :
<%pagetitle = "Title" %> In the header document. My question is where does this go in my header document and how do I reference it in all of my other pages?
On a heavily used page that pulls a lot of data from the SQL server and XMl files we would like to implement refresh of only one data grid control in order to improve performance.
Is there a way to refresh data grid control without (post back) reload of the hole page. Data refresh can be done on regular time intervals or on click on the button. Environment (ASP.NET and SQL Server 2000).
I am passing variables around from page to page using the following:
../new.asp?Info=stuff&name=Fred
then re-capturing it with:
<% 'Get the users info passed from the previous page
strUserInfo = Request.QueryString("info") %>
strUserName = Request.QueryString("name") %>
I use that info to personalize pages:
Hello <% strUserName %>, glad you are back to work on your <% info %>.
This works great for pages/forms that only update a record or display the strings, but the problem I'm having is with a form that creates a brand new record using the passed data.
I use hidden inputs into the new record so that the user does not have to re-enter it but when they hit submit Front Page posts a confirmation page with a link to return to the same form. I need to change that link but cannot figure out where the confirmation page is generated.
while i'm munching on my thai green chicken soup i wonder if anyone can suggest any good code generator out there for producing asp code from microsoft access tables?
View Replies View RelatedTrying to find out if this code is written to query an access or sql database or does it just depend on the connection string ?
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_beero_STRING
Recordset1.Source = "SELECT beer_brewery FROM dbo.BEER WHERE beer_country = '" + Replace(Recordset1__MMColParam, "'", "''") + "' GROUP BY beer_brewery ORDER BY beer_brewery ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
I have ASP project uses Access DB .. I need to convert the site into Mysql. But I keep getting some Runtime Error ( Mismatch ) and I don't know what the problem .. Code:
View Replies View RelatedLooking to populate an access db table 'ole object' field through asp code.
View Replies View RelatedI am having problems with IIS running ASP code against a MySQL database. Everything works fine in Internet Explorer but anytime I use Netscape 7.2 (or Mozilla), it always asks me for a Username and Password.
I can not get Netscape 7.2 to work with IIS so I was wondering if there is another server that I can download to my machine that will allow me to run ASP code against a MySQL database. Does anyone have any recommendations?
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
I am think to write a code that will need more then 2 servers.
Can anyone give me some information to do code like that?
Like yahoo, google, msn.
Could anyone tell me whether either, ASP, or ASP.NET/VB.net or ASP.NET/C# enable me to create a web application with no source code available to be seen by the clients people.
I read something about dll's an using Visual studio.net in another post,Iprefer vb.net or c# cos I am familiar with vb an c# is supposed to be easier than c++
Is it possible to run a Server Side function from JavaScript? I have a dropdown list that executes some javascript in the onChange event, but I need it to query a database after it does so.
View Replies View RelatedI plan to allow users to upload jpegs using the <input type="file">
I understand one needs to install an ASP componenet on the server to handle the upload.
I have an installation executable from CBUupload that is freeware, which apparently can do the job. Also there are a number of options I can purchase. Has anyone any experience with installing these components on a host site?
I've got all these great books and code samples from the internet, but when I try to use them, they don't work!
For example, the following code ignores all the code in the frmTest_OnSubmit, and proceeds to go to the next form as if everything is ok: Code:
Anyone have server side code to password validation?
View Replies View RelatedWe have a report page which deals with more than 3000 records and 80 columns. The records are displayed on a third party control VS flexgrid versioned 7.0.
Currently we are having a client side array populated from the server side using response.write . Is there any other means to optimize the performance on this page?
One of the fields ("Description") in my MSAccess database table contain text formated by HTML tags (<b>, <i>, etc) I now need to display it on asp page, but not as formated text, but as it is stored in my database:
Not like
Description of this product is good.
but as
<b>Description</b> of this product <i>is</i> good.
How can I do this?
How can i get the source code of a web page through asp code?
View Replies View RelatedI just inhereted a website. I made a change to a simple SQL string in a ..aspx.vb page. If I don't have Visual Studio, is there a way to "publish" the pages and show my changes?
View Replies View RelatedI am trying to call a field value from my database - which gets open in an included file (all work on database must be done in that included file), if i use response.write(rst("pagename") it would print fine in the page when I call the sub i.e <% call pageNameFind() %>
But i want to get the field value to appear like this <% PageTitle = pagename %> where pagename comes from the included sub pageNameFind pagename = rst("pagename")
It doesn't pick this up however - how would I do this? This value will then be sent on to another included file at later stage. and I must have the <% PageTitle = myvalue %>.
I got this book for some time. I need to download the source code for this
book. However, Wrox, the publisher, does not have download code for this
book. Could anybody suggest any site from where I can get the download of
source code for this book?