I have customers that I designed a site for. I am almost complete with the site, and they are saying that the font is too small. However, on my computer it looks just like the font on devshed and everyother site. Are there any suggestions out there, as to maybe their settings are messed up or my scripting is bad .
View RepliesI am doing some research into the reporting capabilities provided by ..NET by itself and also integration with other programs such as Crystal Reports or thrid party tools. I don't have much experience with .NET technologies but most of the reports will be requested through the web and produced via VB components with a SQL 2k backend.
I am looking for reports either in xls or pdf format and mostly they will be data intensive i.e. no graphics such as bar or pie charts etc.
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
When using such objects as the one above, where is dbConn actually comming from?
How do I store session variables using the session("") in the code below? Everytime I try doing it, I get an error page.
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
<object RUNAT="Server" ID="spEssRtd_loginValidate" PROGID="adodb.command"></object>
<%@ LANGUAGE=vbscript enablesessionstate=false %> ......
I have written a COM component who's purpose is to allow a user to change
his Windows (NT/AD) password via a web page. Now the component works fine
when I run it in VB 6, but not via the web page. The component also returns
an integer value that contains a return code from the Component (and the
appropriate Windows API). The result (using the ASP page) is Zero, which
indicates success. However the password doesn't change. (Zero = success, 100
= Invalid Domain, 101 = Invalid User, 102 = Invalid Password). Code:
I have two dates formatted as 'General Dates'....
21/08/2006 21:39:21 and 21/08/2006 21:58:48
How do I find the difference between them in seconds? I take it thats there's 2 ways of doing it: either with ASP or SQL. Anyway of doing it. how would I go about doing this?
I have a field called EndTime in a table called tblSessions. This field is a Date type, with a General Date format (DD/MM/YYYY HH/MM/SS). I want an SQL query which can return entities which are less than 30 minutes old.
View Replies View RelatedI have developed asp application, but never worked with shopping
carts. I was wondering, when a user clicks on Add to Cart for a
product, is it done visa session variable, where item detail and price
is stored, and later on, fetched and added together to show total
price?
sometimes but not every time when i upload a fresh copy of my database to my webspace..
i receive this dreaded error..
Provider error '80004005'
Unspecified error
on the line that connects to my database..
Code:
I normally work with MS Access databases using ASP pages. I have been
given the opprotunity to work on some available SQL server space, and
wanted to ask a couple of questions. The following is a simple update
query that I use. It is an ASP page that connects to an MS Access Db:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN = myDSN & "DBQ=xxxxxxxxxxxxxxxdatabase003.mdb"
mySQL="UPDATE SKUList SET SKUList.Department='Furniture' WHERE
SKU='123456'"
Conn.Open(myDSN)
Conn.Execute(mySQL)
Conn.Close
Set Conn = Nothing
%>
I was wondering if someone could tell me (or better yet show me) how
this code would look in a SQL server enviroment. I have no information
on the server itself as the database will be setup for me, and I will
just need to create ASP pages to connect.
when i run the ip of my web site i get the following error:
HTTP 500 - Internal server error
the log file shows the following error:
The server failed to load application '/LM/W3SVC/1/ROOT'. The error was 'General access denied error '.
Periodically, our entire website will display the following error for all
users when requests are made to ASP pages:
DBMSSOCN General Network Error
HTML pages will load just fine, and I *believe* that ASP pages that don't
access SQL Server will also load. Someone suggested this problem has to do
with named pipes, but I don't have any clue when it comes to networking and
our network admin just resigned. This happens very sporadically (maybe once
a day) and never seemed to occur when he had DSN based connections. We also
have migrated our SQL Server to another machine (used to reside on the same
machine as our webserver).
Any ideas on what could be causing this?
What does a website need in order to send
text messaging to cell phones? Is this something the hosting company will
offer or does the website need servers from Micrsoft? Can you refer me to
where I can get more information on this?
can anyone tell me what i have to do with this error ...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xeb0 Thread 0x7a0 DBC 0x1110064 Jet'.
everything was ok until i Compact and Repaire the DataBase
i checked google everyone says it is security problem. i am admin on my computer but still i give all users Full Control Permission for both Temp and server folder "C:Inetpubwwwrootcareer" and i Add Everyone with Full Control but there is no use
any ideas ...
I have the following pages...
page1.asp
page2.asp
page3.asp
page4.asp
page5.asp
The following variables are given values on page1.asp:
FirstName
LastName
Address1
Address2
City
State
Zip
The values are not used in pages 2-4, but are used in page5.asp.
Should I put the values in session variables? Or should I put them in form
post data? Or does it really matter?
I'm trying to add a user to active directory using ASP and am receiving the
following error:-
Active Directory (0x80070005)
General Access Denied Error
Does anyone know how to get round this problem?
At the core of my DB schema is a request table. This entity has one or
more assignment records and each assignment record has one or more
assignment log records. The log tracks assignment actions such as hold,
release, open, close, etc.
In VB, I would normally create Request, Assignment, and AssignmentLog for
the data. I would also create two custom collections for Assignments and
AssignmentLogs. Given any Request ID, I could populate everything else
with encapsulated queries and recordsets. The request object could
implement properties to give the currently assigned helper, open state,
elapsed time, etc.
My question to you is; how to I implement this model for the Web? As I
understand it, web objects are stateless. If my request object can't
persist its data in memory, then does it have to fire a query every time
the caller wants a property value? Will I always have to pass the
RequestID in as a parameter?
If I wanted to write my own blog application, what functionality should it contain?
View Replies View RelatedI want to write a shop content management system in ASP.However the database holding the products for sale will be on a different pc to the webserver.I do not want the remote webserver pc to authenticate against the sql server.
Ideally the cms should produce static html pages which could be indexed by a search engine.So far,the most likely solution will be for the web pages to include javascript includes which will reference an asp page on the same machine which houses the sql server, this will then insert the values into the web page at run time.
I could make it so that the sql server PC creates the entire website, then automatically ftps' it to the remote website - however the problem here would be that the ftp would probably go wrong a lot and generate loads of support calls.
which is a better model to implement to design a database with all the constraints during the design of tables, etc, etc or to write the code ( in asp ) and implement the constraints needed when storing data by means of the code.
View Replies View RelatedWhy d I get this error?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x18c8 Thread 0x1478 DBC 0x2f56fa4 Jet'.
/wheelofgod/search/cat/showbook.asp, line 102
I will have a web site where hotels can list themselves on it.One thing I am encountering that is a challenge, is that every hotel has different types of rooms. Also, every hotel has the normal high and low seasons, and some even have more seasons such as shoulder, weekend, etc. which affect room rates. So here is how I concieve the design:
First, allow hotels to specify how many seasons they have, perhaps with a drop-down box of values such as 1,2,3...6,7 etc. They would then be presented with a series of text boxes, and asked to define the season, such as "High" "Low", etc. Adjacent to every season would be a beginning and ending date for that season. Next, they would be asked how many types of rooms they have, such as a drop down with 1,2,3,....5,6,7. Once decided,a form would present itself with form fields for the each room, such as description, ameneities, and most importanty, rates PER season. The seasons would be defined from previous step and would be unique for each hotel.
Once complete, this would give a web site where I could list hotels and each would have its seasons, rooms and rates listed uniquely.Is this a good concept?
yet my colleague can? (when looking at exactly the same page - same destination folder etc)
Is there some sort of setting, so that you dont only see those small yellow ASP blocks when looking at the design view, and see the layout of the page , with the tables etc?
I realise that most of you gurus dont use the design view at all, but it is something that using ASP,
I need to have a webpage that starts off with content down the side and along the top, when the respective top and side have a value id like it showing up at where the side and the top meet. I had tables in my database that linked up and when I ran a form with a subform it seemed to work well.
But I cant seem to get anywhere close to pulling the data down correctly to a webpage so help.Its difficult to kinda explain what I want to do and I seem to be having a difficult time making it run properly.
how most of ya'll design your databases and why in that particular way? I'm specifically interested in setting up tables in which the data are linked.ie:table1 contain registration information and table2 contains account information and comments.
How would I link these? I'm thinking using a standard primary such as autonum and when they register to write to the two tables but i might be mistaken.
I am currently creating an intranet application, in which the staff will be able to create their personal profile uploading their pictures and such. Now i have tend to act cautious when users need to upload their picture. i have set the maximnum size to 30kb.
my project manager seem to think otherwise saying this might discourage pple from using the application. I need some advice though as regards the maximum size of the picture.
Also, does ASP has any inbuilt object that can resize a picture before storing in a database.
I have coded my pages in HTML and named them as ASP. I would like to use a trailing string i.e. domain.com/page.asp@somthing=4 . which pulls from a database of plan names and corresponding prices over a user selected interval. I want to offer pricing over these intervals:
1month
3months
6months
12months
24months
with a percentage discount being offered for each greater length of time. The user should be able to use radio buttons to select how to pay and after this a paypal button should be generated with the designated amount.
Now that I have layed out what my intensions are, does anyone have any ideas of how to complete my goals using ASP? and if ASP will not do the trick does anyone know of a better/differnat way to do this.
I need some help optimising my object design. Since one article has 1+
authors, I assume the logical way to represent this is for my Article object
to have a Authors property, of type "array", capable of representing any
number of authors.
The code I have written (below) works, but is very inefficient; if I want
the asp page to fetch a list of 30 authors using GetAuthors(30), there will
be a total of *31* calls to the database - one call in GetArticles(), and
one call to GetAuthors() for EACH article! Code:
I have an array of records, would like to put them into X no of tables depending on the number of records. The max X is 3. For eg, i have 15 records in the array
I would to have record 0,3,6,9,12,15 in table 1,record 1,4,7,10,13 in table 2, record 2,5,8,11,14 in table 3.
I tried to use 3 for loop, it did the job but is there a better way to do.?
We have a cart we built using sessions, it has been fine until now where our server times out at 20 mins no matter what we or the server techs do, so now we want to redesign the cart using tables soley, can this be done?
If so is there any disadvanages of doing this? Anyone know of a tutorial to do this so we can get started?
I'm using GET to pass variables from a page that consists of 20 choices that each redirect to a different page. I had originally planned on making 20 form, which would allow me to use jpeg images for the buttons.
The problem I am having is if you put forms one under the other, the browser puts a carriage return between them...and it's making my page much larger than I would like. Is there a way to pass the variables using GET(or any other method) that would allow me to use links instead of images?
This string is supposed to provide all records from an MDB database
that match the courier and date specified in the query. I
Response.Write the query and I get a date as 1/27/2007. The date
format style is exactly the field specification as I see in the MDB
Date field in the Courier table. The data for this query exists - both
the courier and date that I'm selecting.
However, when the file continues processing and the results are
displayed - no data!
What am I doing wrong here? Why would an MDB not understand a date
format of mm/dd/yyyy if that is what I'm explicitly seeing in the
field of the table? There are no constraints on the field design.
'<snip of the code>
cfedexSQLstr = "SELECT * FROM Courier WHERE Courier.Courier = 'Fedex'
AND Courier.Date = " & strDate & ""
I would like to create a chat room but I don't know where to start. for example:
Should I create a database for the user input and output. I never done this before.
My coding experience comes from mostly application development instead of web coding. In the application world, if the user receives a system error, a new form would display the error, with any helpful information for the user and the application administer. This way there is a systematic way to handle errors. In the web world, how is this done?
For example, if I have a form where the user is entering data to be inserted into a DB. Is this the correct flow of pages?
-On submit of Entry form, an ASP page is called to insert the data -If insert successful, take the user to the next logical page -If insert not successful, display an error.htm page.
Basically, the entry page does not have the insert SQL and if there is an error in the insert (not because of missing fields because those are handled with JavaScript before submit), the error is displayed on a completely different page. Is this correct flow?