Database Connection
I need to use the Database Results Wizard to
make a connection to a database that is outside
of the current web. I cannot figure out how to
do this.
My database is in a different folder than my site
on my web server. The layout is like this:
Database Location:
C:\inetpub\wwwPortal\db\database.mdb
Web Site Location:
C:\inetpub\wwwPortal\html
With the DRW, I can only figure out how to
make a connection to the database if it were
in the 'html' folder. As far as I can tell, it will
not let me make a connection to the 'db' folder
that is outside of the web.
I have multiple forms on my site that I am able
to write information to the db. I just cannot
pull information from it using the DRW.
Any help would be appreciated.
Mike Tag: Publishing on CD-ROM Tag: 25559
Frontpage minus XML
Any way of making frontpage only use raw html rather than include xml when
creating web pages?
(Go Blue!) Tag: Publishing on CD-ROM Tag: 25552
Appropriate DOCTYPE for XML Formatting Rules
Hi All,
I have what is quite possibly a stupid question about XML formatting and
DOCTYPE declarations. I am using FrontPage 2003 to apply XML formatting
rules to my web pages by right clicking in the code view and selecting
"Apply XML Formatting Rules". Using the command made changes similar to the
following:
Original Line:
<img src="my_image.gif" width="35" height="9" alt="alt_text">
New Line (the only difference is the forward-slash at the end):
<img src="my_image.gif" width="35" height="9" alt="alt_text" />
My question is: If I use XML formatting is it still appropriate to use the
DOCTYPE declaration shown below or do I have to use some sort of XML
declaration.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
Thank-You,
Kris Tag: Publishing on CD-ROM Tag: 25551
[ANN]: NNTP Server slow downs.
For several days, we have been experiencing slowdowns in the Microsoft
newsgroups. The combination of the recent waves of spam and viruses
generated several issues that Microsoft teams are troubleshooting now. In
the meantime, to help deal with the slowdowns, we are reducing our message
archive from 90 days to 30 days for newsreaders (such as Outlook Express).
To access discussions older than 30 days, you can use this page:
http://www.microsoft.com/communities/newsgroups/default.mspx
Regards,
Microsoft Communities Team Tag: Publishing on CD-ROM Tag: 25535
Display IP address in confirmation form...
Hello, I need to display the IP of the person filling out
a form in my site.
I want it to appear in the confirmation page.
Suggestions???
Please help me, thanx.
jpmaster Tag: Publishing on CD-ROM Tag: 25530
SQL2K Server and IIS 5.0 connectivity with FrontPage 2K
Hello, I hope someone out there can help me understand.
I have an IIS Server and using FP2K, I'm trying to connect to a SQL2K
Server, but I keep getting errors in attempting to connect.
I have searched the newsgroups and had no luck in finding a solution. The
error code that I get, refers to Named Pipe, error 80004005, cannot connect.
Anyone have any ideas?????
Thank you
Luis Aguilar Tag: Publishing on CD-ROM Tag: 25522
ASP SQL String error
I'm, trying to generate a random number to be used in a DB lookup of wav
files that can be used as BG sound bytes.
I'm missing something along the STRSQL = line that's blocking me.
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "SELECT WavName FROM "]'
/random_number.asp, line 21
The number generates correctly and the field being selected is the primary
index and an integer (autonumber).
I generate an SQL pull that will work correctly with DATABASE results
wizzard, but not with a random number.
Can anyone see a problem in my syntax?
___________________
<%
Dim intLB
Dim intUB
Dim intRange
Dim sngRanVal
Dim intRanInt
Dim DSN_Name
DSN_Name = Application("Web_ConnectionString")
set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN_Name
Set RS = Server.CreateObject("ADODB.Recordset")
intLB = 1
intUB = 30
Randomize()
intRange = intUB - intLB + 1
sngRanVal = intRange * Rnd()
sngRanVal = sngRanVal + intLB
intRanInt = Int(sngRanVal)
strSql = "SELECT WavName FROM WavTable WHERE ( ID = ::'" + intRanInt + "
::)"'"
RS.Open strSql, Connection
Dim SNDFile
SNDFile = rs("wavename")
RS.close
Connection.close
%>
<html>
<head>
<title>Random BG Sound</title>
<bgsound src ="sounds/wavtable/<%=SNDFile%>">
</head>
</body>
</html>
_____________________________________ Tag: Publishing on CD-ROM Tag: 25519
creating a download file
How can I make a file or image file downloadable when
clicked upon? I need for my client to be able to
download there image files if needed from my site. Tag: Publishing on CD-ROM Tag: 25513
Further form query
I posted here a week ago about formatting the emailed results from an FP
form - the emailed results need to be really easy to read. Thanks to those
who answered, saying that FP can't do that.
I've been looking around and I keep coming across ASP, and I gather I can
send the results to an ASP script? This is all completely new to me, but if
anyone could give me any hints as to my next step, or has any experience of
this, I'd be really grateful. Are there scripts you can download and use?
Any help etc... cause it all looks greek to me at the mo...
Likewise Tag: Publishing on CD-ROM Tag: 25512
Downloading
Hi -
I'm not even sure this is the correct newsgroup for this
question: Is there a way for me to add an area on a
webpage for a User to download a picture that I have?
Thanks -
Melissa Tag: Publishing on CD-ROM Tag: 25511
Adding a Date to Records
I'm trying to build a page that updates a feild in a
database of when a record was edited. The pages adds the
date of when the record was entered already. What I need
it away to add a date of when the record was edited and
the user can't change this date.
Thanks,
DeWayne Tag: Publishing on CD-ROM Tag: 25510
Error in newgroup?
Sorry that I ask this in this group -
Yesterday I posted a question under Frontpage - general
questions, but today when I enter the newsgroup, it only
says "Newsgroup not available". None of the 2500 pages
are available.
Is this a current general problem or am I doing something
wrong??
Thanks Tag: Publishing on CD-ROM Tag: 25509
background resizing when display properties is reset.
Using frontpage 2002, using background jpg for top of web
page.
how can I stop the background picture from repeating when
the display properties are changed from 800x600 to
1024x768 ?
thank you
James Tag: Publishing on CD-ROM Tag: 25505
wrapping problem on results page
When data is entered into a submit page without new line
breaks, it is displayed in the results page as one long
line. There doesn't seem to be a way to force a line wrap.
Got any answers?? Tag: Publishing on CD-ROM Tag: 25504
Adding footer to DBase results page...
I wish to add a footer (html) to the bottom of the DBase results pages in my
site.
Problem is, since these pages are dynamically sized, I need the footer
dynamically placed. Something like "x pixels below the DBase region".
To compound the problem, there are lists of links down the left side of the
page. I need the footer to be placed no higher on the page than "x pixels
below the bottom of the list" as well as the above criteria.
So far, I can't even figure out where to place the html for the footer so
that the footer appears at the bottom of the DBase results. I'm sure this is
possilble since FP is placing "buttons" at the bottom of a full page of
results. I've tried several things including [fpdbrgn2.inc] and can't seem
to get anywhere.
For now, I have the footer placed statically at the bottom of the results
page.
If you wish to view, the "home page" for the site is
http://www.zartbooks.com/zartbooks1.html
(Be aware, this site is not yet "live"; don't attempt to purchase anything
yet...)
Any ideas??
Thanks,
skorpion@suespammers.org Tag: Publishing on CD-ROM Tag: 25503
ERROR 2?
I just got a new web site through Interchange. The name
of it "www.sbcyouth.org" is unavailable, because it has
to circulate through the Internet for a few days first.
Well I tried to publish in FP 2000 using its I.P.address,
but when I do I get an error message.
It reads:
Server error 2: Error 2 opening registry
key "SOFTWARE\Microsoft\Shared Tools\Web Server
Extensions\Ports\Port 80".
What's the problem? Can I fix it with "regedit"? How do
I fix it?
Thanks,
James Tag: Publishing on CD-ROM Tag: 25500
Hex characters in JavaScript
Not strictly Front Page but anyway ...
I need to examine a string from an html form text area
field and check for certain characters using the
string.substring(a,b) function or similar.
If the characters are normal like "a" then OK but if a
line throw character is found, I need to replace it with a
normal character like "+".
I guess I need to do some stuff with hex etc.
Something like, say, for the 3rd character of the string :-
linethrowchar = "#0C"; // if this is correct?
if (fieldstring.substring(2,1) == linethrowchar)
{fieldstring.substring(2,1) = "+";}
You get the idea anyway ... does it need eval or something?
When I look around about Hex it always seems to be
something about colors. Tag: Publishing on CD-ROM Tag: 25499
formatting 101
Sorry to ask such a basic question, but how do I ensure
that my website appears the same no matter what
resolution setting a visitor may have? I've discovered
that my site loses its format if the site was not created
using the same resolution as the user... Tag: Publishing on CD-ROM Tag: 25498
Hover Buttons do not display in IE6
Hover buttons work on some computers with IE but not
others. I'm sure it must be an operation system problem
(XP) and not a frontpage problem, but I'm stuck.
Thanks Tag: Publishing on CD-ROM Tag: 25496
Banner Ad Manager Properties
I'm sure this might sound like a silly question, but I'm
really new to FrontPage, so I hope you will be forgiving.
I inserted a Banner Ad in my homepage, inserted 7
pictures for it to flash between. It seems to work
perfectly when I view it IN FRONTPAGE, but when you
actually visit the site, all you see is a lovely gray box
where all this fun stuff should be happening.
What am I doing wrong? (please)
Any help would save many dosages of Aspirin.
Thank you,
Missy Tag: Publishing on CD-ROM Tag: 25495
Embedding pages
Please help me!
Hi all, I'm new to FP2002 and getting very frustrated with
this! I've embedded pages (my left side naviagtion, header
and footer) using the "Include Content" Web Component on
my home page. Here's my problem: In my footer page, I use
CSS for my links (a:link, a:active, a:hover, a:visited).
My CSS works fine on my footer page when I view it. BUT,
when I include the footer page on my home page using the
Include Content Web Component, it includes the actual
footer links, but the CSS won't work. (there isn't any
other CSS in the home page code that could possibly
override it either). Why is this happening and how do i
fix it, and if CSS won't work with the include content
component, is there an alternative to using CSS for my
links? THANK YOU!!!
Sincerely,
Jill Tag: Publishing on CD-ROM Tag: 25494
images
Previews in Front Page work just fine, but when i go to
open the page in a browser my inserted pictures dont' show
and when right clicked redirect to an error page reading
"The requested URL /~----/folder/images/image.jpg was not
found on this server.
Additionally, a 404 Not Found error was encountered while
trying to use an ErrorDocument to handle the request. " Tag: Publishing on CD-ROM Tag: 25490
Quick Hyperlinks and the pesky UP tag
Hi!
I'm a new FP user and have am stumped! In my hyperlink
navigation bar I have a link back to the parent page - its
labeled "UP" by default (via FP).
Can someone help me so that I can get my boss off my
back? He wants it to say "TOP". I don't want to change
it outside of FP because someone will have to remember to
do it after I'm long gone.
I thought I stumbled upon a dialog box once that would let
me change it but I can't remember.
Thanks for the help. Tag: Publishing on CD-ROM Tag: 25489
Format date on ASP
I have two fields that come in from an access database. I
can't change the way they are formatted in the database,
so have to format them in my script when they come in.
Currently I have them both set to come in as mm/dd/yyyy by
using the following: formatdatetime(trim(oRsWD.fields
("first_day_of_month").value ),0)
How can I get the date to be formatted so it appears 09-
Sep-2003??
Thank you!!
Ginni Tag: Publishing on CD-ROM Tag: 25487
Displaying the contents of a file in a text box
Can someone tell me how to display the contents of a file
in a text box. I'm using a single page to display
information from several files that change often. I want
to display the contents of those files without having the
user click on a hyperlink. Thanks! Tag: Publishing on CD-ROM Tag: 25486
Frameset code
I have managed to somehow change the file location of my
frames pages within the code of my frameset. Does anyone
know how I can open and view the frameset code? I can
not seem to find where it is saved. Tag: Publishing on CD-ROM Tag: 25481
Will not display interactive excel database
I'm trying to put a usable database in a clients website,
and it works when it's still on a local drive, but when I
upload it to a server, it shows s blank sqaure with a
picture icon (what it shows before a picture loads on
websites) and the explorer is finished loading
everything. I've tried it on two different server, I put
it on my own server first, and that didn't work, so I
tried one of those free webhost servers "tripod" and that
didn't work. fyi: I am using Internet Explorer 6.01
Please help, Email me at golfandsurf@ec.rr.com
The sooner the better!
Thankyou Tag: Publishing on CD-ROM Tag: 25478
Publishing server web to local computer "My Web"
I can work "live" and edit the website, but when I get
done, I cannot backup the server web to my local computer
as it simply terminates the connection after a while and
I do not have the web published locally. Interland said
it "timed out" and that is a "Front Page" issue. Anyone
have a solution? It just started this recently after
some Office Updates... Tag: Publishing on CD-ROM Tag: 25477
How to enable client to update?
I am using FrontPage 2003. My client wants to update a
newsletter in her site herself. She does not have
Frontpage - nor do I want her to have access to the whole
site. How can I accomplish this?
Thanks in advance. Tag: Publishing on CD-ROM Tag: 25474
Shared borders
I've been trying to shrink the size of my left shared border using tables
and images, but as soon as I add the link bar it goes back to it's standard
size. I tried shrinking the images used for the links. I started off without
images, just print, and now that I've added a theme and fancier links, I'm
finding the page is cut off a bit at the right. Any help appreciated Tag: Publishing on CD-ROM Tag: 25471
Problem w/ FP2003
I installed the beta of FP 2003 to try it out, but I keep
getting an error everytime I try to run it. I
uninstalled, reinstalled to no avail.
Any ideas?
Mark Tag: Publishing on CD-ROM Tag: 25470
Junk Email
I posted a question a few days ago and now Im getting a
bunch of junk mail Like 33 last night. All the same
message that starts out with: ALERT!!!
This e-mail in its original form contained one or more
attached files that were infected with a virus or worm, or
contained another type of security threat.
The message are from:
Microsoft Corporation Customer support
Network Email Storage Service
Technical Services Internet Security Department
Microsoft Internet Service
Microsoft Security Section
WHY IS THIS? AND HOW DO I STOP IT? Tag: Publishing on CD-ROM Tag: 25469
Ensure that my contents frame is shown
Hi,
I'm very new to all this stuff and would appreciate some help.
I would like to ensure that if someone is directed to my website from a
search engine rather than coming in from the home page, that the contents
frame is displayed. E.g., if you go to
http://www.danielklann.com/Excel/importing_large_text_files_into.htm you'll
just see a page. However, if you go to www.danielklann.com you'll see that
there is a frame to the left of the page with a contents section. How do I
ensure that if someone loads up any page in my site then the contents will
also be displayed?
Thanks for reading (and maybe helping),
Daniel Klann Tag: Publishing on CD-ROM Tag: 25467
Can FrontPage do 'freeze panes' that similar to Excel??
Hi,
I'm the ordinary guy who used Excel document (*.xls) to
save into HTML (*.html) and later used to modify the HTML
using FrontPage.
My Excel already having the 'freeze panes' function in use
but wonder why it wasn't tranfer to my HTML file when i
saving it to HTML format.
Hope if anyone here knwo how to do 'freeze panes' in
FrontPage, thanks in advance!!
Kazat Tag: Publishing on CD-ROM Tag: 25465
Auto form fill in
Does anyone know how to set up the form in frontpage so
that when say a user selcets a date in the form field
below it will automatically fill in the day in the day
field with out the user having to put in the day field
themselves.
Look forward to your suggestions
Many Thanks Tag: Publishing on CD-ROM Tag: 25464