Database Design
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.
View Replies
ADVERTISEMENT
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.
View Replies
View Related
our database could be designed better because the more tables we have in our database, the less efficient it will be with a lot of activity. our database uses mysql and currently has about 6000 tables in it.
here's how i need the site to be. first of all, it's a gaming site, so if anyone has gaming knowledge that will help. for the tables, i currently have one table for each game that's. Code:
View Replies
View Related
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?
View Replies
View Related
If I wanted to write my own blog application, what functionality should it contain?
View Replies
View Related
I 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.
View Replies
View Related
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 Related
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?
View Replies
View Related
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,
View Replies
View Related
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 Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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 & ""
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
I have an ASP site with about 50 ASP files, all of which are currently including a common "includes.asp" file near the top of the file, responsible for generating the <HEAD/> section of the HTML.
I need to make a change for 3 of those ASP files such that some dynamic HTML is generated in the <HEAD/> section. I want those dynamic HTML to appear only for 3 specific ASP files. Is there a more elegant way other than to:
1) Dim strOptionalDymanmicHtml1 in includes.asp
2) Initialise strOptionalDymanmicHtml1 to "" in includes.asp
3) In the 3 ASP files which require additional optional dynamic HTML,
initiliase strOptionalDymanmicHtml1 *before* including includes.asp
There is an additional even more tricky problem, I have most file taking this structure Code:
View Replies
View Related
I need to create dynamicly an ouput table that users can edit their hours and cost center. Each day have maximum 2 entries for week if they have one entry per week, then the design table will have an empty text box for users to enter in.see the attached outline to show the weekly timesheet in edit mode. Below is the query I am using it ....
View Replies
View Related
I work for a Startup based out of San Diego, CA. We are succesfull team of entrepreneurs with a proven track record. We have finished an initial design for a site that helps people be more productive with social networking aspects. This means we have a bunch of use cases and wireframes completed. We need help in putting it all together and creating a great overall design.
We are looking for referrals from the community for designers with solid portfolios. West Coast bases teams/indivduals are preferred.
View Replies
View Related
Is it possible to implement a Service to Worker design pattern using ASP Classic?
For example, lets say I want to design an e-mail process.
My EmailEntity.asp would include:
toAddress
fromAddress
emailSubject
emailBody
Then I would want a driving event which would create an EmailEntity.asp. It would then populate the toAddress, fromAddress, emailSubject and emailBody. It would then call an email generating .asp file.
I can does this in Java at work but I was curious if I could use this pattern using ASP Classic.
View Replies
View Related
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables.
I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
View Replies
View Related
I have 2 include files on my page which are both navigation bars. When i view my pages in IE they look fine and everything is in the correct place, however the problem is that when i look at the pages in design view in Dreamweaver i can only see my first include file. the rest of the page is not displayed so makes designing hard as i cant really see what i am doing until i view my page in IE.
WHY IS IT DOING THIS???????????????? Or is this meant to happen, i have never used include files before, but im assuming this shouldnt happen?
View Replies
View Related
Got an item master, think of it like an inventory: description, supplier, cost, unit of measure, etc.
There is an item_type field, which, when set to a particular value, REQUIRES that labor be also entered for this inventory item. I was going to just show/hide a part of the form, but the kicker is that more than 1 labor item can be entered for each inventory item.
View Replies
View Related
I need to create dynamicly an ouput table that users can edit their hours and cost center. Each day have maximum 2 entries for week if they have one entry per week, then the design table will have an empty text box for users to enter in....
Please see the attached outline to show the weekly timesheet in edit mode. Below is the query I am using it. Code:
View Replies
View Related
I want to create a webpage with asp. on that website, clients can get data from the
database with SQL.
I can already view the report in the crystal reports viewer on my asp page, but i want to
design the report at that time. is that possible? i have read something about RDC, but is there another way to do it. i don`t have VB experience and tolls to use RDC.
View Replies
View Related
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
View Replies
View Related
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
View Replies
View Related
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies
View Related
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
View Replies
View Related
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
View Replies
View Related
