How To Include Id# Field Of Db In Url?
There's a problem with dropdown's name="id" (referring to the id field taken from the value="<%=rs("id")%>").
WHen I change name="id" to name="book" and value="<%=rs("id")%>" to value="<%=rs("book")%>" I would get:
showverse.asp?book=(with the right number with the beginning of that book. But it needs to be more precise, down to the right id)
But if I leave it as "id" although the url will give:
showverse.asp?id=(with the right number but goes to the very first book and chapter)
Code:
View Replies
ADVERTISEMENT
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
View Replies
View Related
I want to be to call my menu from another file onto my page so that i dont have to add it to every page of my website. The problem is when i try to add it using the include method it says that only one include file is allowed on an ASP. The other include file is my connection string so i cant really take that out of the page because then nothing else will work!
How can i get the menu page included as well as the connecting string?
Have added the code below, i have highlighted the 2 include files that i want to use in blue, i have also left the div tag in for where i currently have the menu which is what i want to take out and have ther include file there instead, if that makes sense. Basically the bit in red i want to be able to remove from all of my pages and add the blue file above the red code in instead, but i dont know how!!!!! Code:
View Replies
View Related
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
View Replies
View Related
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
View Replies
View Related
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
View Replies
View Related
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
View Replies
View Related
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
View Replies
View Related
How i can do <!--#include file="filename"--> dynamic with ASP, or any other way
View Replies
View Related
If I want to include a file to my webpage that is not placed in the same
folder asd the application, but in another folder on the same disk...
I found out that this is not going to work:
<!--#include virtual="D:/binaer.no/nova/test.asp"-->
Is there any other way to include from another domain account on the same
server?
There is going to be several applications that includes the same file, so
the trix ../../../ will not do it for me...
View Replies
View Related
<%
I am trying to use "set con" in the include file. i used it before with simple text but when I use the connection object it doesn t work. is this possible in asp and what is the problem with the code below:
inc.asp file
VARMSG = "set con = Server.CreateObject("ADODB.connection")"
con.Open ("dsn=project;uid=sa;pwd=sa")
%>
mainpage.asp
<!-- #include file="inc.asp" -->
<%
Response.write
set rsTypes = con.execute("select * from firstmarch order by cat")
%>
View Replies
View Related
Can someone advise how can I send an html message that include gif file using cdonts.
the gif cannot link to www, or any specific server location. user must be able to view when they open their email.no as attachment.
View Replies
View Related
I have asp page file0.asp which calls another asp page thru include. I have to set conditions tht....
originally the include should have file1.asp In the displayed file file1.asp user selects a hyperlink, it should take it as request and display the new file2.asp in same file0.asp in place of file1.asp.
so i want to display multiple pages on user request inside file0.asp. But originally when file0.asp loads it should have file1.asp. Code:
View Replies
View Related
how to include an asp file into an other asp file with checking condition first.I can do this easily in PHP, but in ASP, it seem that the content of included file is process before it read the code on page.So when I include a asp page into another asp page, I cannot choose which page will be include base on the condition.
View Replies
View Related
make a script for my forums (the header) involving the date and an included page. Quote:
If the month is 9 (September) then include page x
elseif the month is 10 (October) then include page y
else include page z
How do I go about doing that? I know how to do it in php, but I'm looking to do it with asp.
View Replies
View Related
I m trying to test an include example using the code below, but the page "aspsrc.asp" cannot be displayed.
--->aspsrc.inc page
<%
var msg = "testing testing"
%>
-->inc.asp page
<!-- include statement not to be placed within ASP delimiters -->
<!-- #include file=".aspsrc.inc" -->
<%
Response.Write( msg );
%>
View Replies
View Related
When I first started using Server Side Includes I used the regular file include:
Code:
<!--#include file = "myfile.asp"-->
Then I read where the virtual include is much beter. I figured I would try it out, so on my last project I used all virtual includes:
Code:
<!--#include virtual = "/somedirectory/somefile.asp"-->
It worked fine and I really couldn't tell any differnce. Maybe a little easier to remember where all the file needed to point to. But this was for a New Site so testing it on the server was easy. I didn't have to worry about existing content up there.
I'm now redesigning a site to add in some dynamic stuff and I always test everything on the server it will reside on to be sure everything will work. Typically I create a "v2" directory and run everything from there. Well this really screws me up when using a virtual include, becuase I would have to edit and then rededit all my file paths.
So my question is... What do you use? And why are file includes so bad?
View Replies
View Related
i'm calling an include file from within a <td> tag of an existing include file (i'm calling the adroator component from the head.asp file.
i'm getting the following error
Error Type:
MSWC.Adrotator (0x80004005)
ERROR Cannot load rotation schedule file
/root/includes/adrotator/adrotatorhomepage.asp, line 14
the include file head.asp is located in the includes directory while the ssi its calling is on the adrotator directory. here is the code for the adrotatorhomepage.asp (all relevant files are in the same directory) Code:
View Replies
View Related
I'm wondering if there's any way to include a XML file (with a XSL) in a ASP file? I've tried this <!--#include file="publications.xml"--> but the XML-code is included before it is formated according to the XSL and ends up being unformated.
View Replies
View Related
I'm trying to include a plain html file in my asp page, but don't know how to include since SSI is deactivated(?)
View Replies
View Related
how would i get something like this to work...
<!-- #include file="<%=Request.GetString("view")%>.txt" -->
i know wat i want and all but i can't figure out how to make it work.
View Replies
View Related
Is there a way to INCLUDE a file BELOW the web root directory?
View Replies
View Related
I want to include files, a header and a footer to my asp page. The files i want to include its on another server, i can reach it with a www-url. Can i use the www-url to include the file to asp page?
View Replies
View Related
Im working on a new site and im not using frames, im using #include files. The isse is you cant put a variable into an include file because includes are loaded befor variables and this means that the include dont work...
what ive done is make an include page with a quirystring passing which page i want to load in, then on the included page it looks at the case and when it = 2 for example. it loads whats in case 2 which in this case is <!--#include file="../XtraNET/Forum.asp"-->
trubble is theres 52 menu items, if the site would always have 52 menu items this would be solved, but you can add new ones.. thusly i need to be able to dynamic the code...
My train of thought is can i store the whole <!--#include file="../XtraNET/LiveChat.asp"--> statement in the database and call it within the code dynamicly, like a document.write or somthing.
View Replies
View Related
I just started ASP/ASP.NET two days ago. I would like to know the best way to go about using this include file method to contain my connection string stuff. As I understand it, a connection should only last as long as the query action (unlike VB6 with a persistent connection.)
So, what would be the best stuff to put into an include file for my connection stuff so I only have to make one change throughout the ASP/ASP.NET app?
Any other experiences with good things to put in that include file?
Can I also create the connection object in the include file and use it in multiple pages?
View Replies
View Related
I need to include an asp file from another server.Code:
<!--#include file="SicurezzaDip.asp"-->
I think that is the normal way to do it. I've also used the code shown below, but it doesn't seem to work..Is it possible to Include asp files from another server ? How can i do it
Code:
<!--#include file="http://81.74.60.30/Asp/SicurezzaDip.asp"-->
View Replies
View Related
I have been avoiding this issue but it keeps popping up and I cannot figure out a solution. Include statements pathed two or more folders deep they break.
This works:
<!--#include file="../includes/mo_security.asp" -->
This does not work:
<!--#include file="../../includes/mo_security.asp" -->
So basically my site files are limited to one folder deep.
Ex: ROOT/parentFolder/files.htm
One I move another level down the includes do not work anymore:
Ex: ROOT/parentFolder/childFolder/files.htm
I am on a Windows IIS server. Is there any solution to this or is it just a limitation of the include statement?
View Replies
View Related
I've got and old ASP script that works Ok, but I want now to include it within a new ASPX script I've just created with '.net'.
The process could be: Code:
<%@ Page Language="VB" %>
<%
... aspx code ...
include my old ASP script
%>
I'm newbie in ASP, and would be extremely obliged if anybody could tell me how I must write it. I've tried with:
<!-- #Include File="old-script.asp" -->
but it doesn't work.
View Replies
View Related
How can I include a .cgi file in an .ASP file?
I've tried #include, Server.Transfer, and Server.Execute (yes, I know the last two are
only for ASP, but I tried it anyway).
If I have to, I guess I'll use ASPHTTP to do an http call to the file but first I wanted
to see if there was a more elegant way to do it
Is there an efficient way to include the output of a .cgi file in an ASP file?
View Replies
View Related
I've created two separate files that I use as includes to display the header and footer of each page.Everything works fine if the pages that contain the includes remain in the same directory: the root directory. However, I want to use the includes in other places but I can't figure out a good way to solve the problem of the paths that are in the actual include files (path to stylesheet in the header, etc.).
Here is my basic directory structure on the web server (I've used "code" to make it easier to read):
Code:
- root
- include
header.asp
footer.asp
+ images
- misc
contact.asp
index.asp
I want to use the same include files in contact.asp but, obviously, the paths are going to be wrong. I've tried using Server.MapPath in the paths of header.asp and footer.asp so that the includes can be used anywhere in the site but, it is not working.And, I don't want to have the physical path visible in the source code. Is there a function or method I don't know about that can give me a path to the "root"?What have you done if in a similar situation?
View Replies
View Related
how can i include a webpage from another server with ASP? (Without frames)
i tried XMLHTTP, but i loose the stylesheet, images src and relative links
of the included page.
View Replies
View Related
I've only recently begun using asp so i'm not that good, but my problem is this:
The navigation for my site is within an include file. However I have an inlcude navigation file for each section but the only thing that changes from file to file is the name of the section you are in, this seems a bit un-necessary.I.e contact, home, about us etc. Is there a way I can use asp to write the name of the section and so only need one navigation include file?
View Replies
View Related
I want to include files, a header and a footer to my asp page. The files i want to include its on another server, i can reach it with a www-url. Can i use the www-url to include the file to asp page?
View Replies
View Related