photo gallery

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Programming
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Question ,may be way off topic , please help I know that this may not fall into any of the groups taht i'm posting to ,but i would like some help if possible ,,,at least a point in the right direction. I'm running a website and i'm looking for some games to put up on the site ,,along the lines of the card games on Yahoo ,,,does anyone know where i could find some of these??? Thanks for any help forthcoming ,,i;'ve had a heck of a time finding anything about this. Gord Tag: photo gallery Tag: 46594
  - 2
    - Newbie question about forms 1. I've created a simple form for our sharepoint portal using FP2003. I would like to have the form emailed to three different addresses. I've gotten it to work with a single address but not multiple addresses. 2. I would also like to have a date chosen by selecting a calendar. Highlight a date on the calendar and have it entered on the form. Help needed solving this issue. Thanks in advance. Tag: photo gallery Tag: 46588
  - 3
    - Active Links...with Frames My web has 3 frames - Navigation, Header, and Body. Unlike many framed sites, I want to change both the header and body when a link is clicked on the Nav bar. At the moment, my needs are met by changing all three frames on a Nav bar click. There are two problems: 1. I have reload the nav frame every time (minor download time and flicker) 2. the particular link on the nav frame does not stay the active link. For example, http://www.writeonwhidbey.org/2005_Conference/2005_Conf_Home.htm On this page the header is used to hold links to sub-pages. If you click one of these "header-links" it becomes the active link for that page, and shows up as WHITE. This is a nice reminder for the user to know where she/he is. I'd really like to have the appropriate link on the left ("Writers Conference" on the above page) also be a different color...white...to indicate that this set of pages is associated with the "Writers Conference." An unacceptable solution would be to actually have a different Nav bar frame for each major section. Changes seem to be made too often to the nav bar to make this a viable solution. Change one and you should really change them all. The only solution I can think of is to load only two frames when a nav bar link is clicked. Is there a way to TARGET more than one frame; i.e. load two frames out of three when I click a link? TIA Bob Tag: photo gallery Tag: 46584
  - 4
    - Frontpage local web has changed after re-installation We have had problems with viruses after changing from Norton AntiVirus 2002 to 2004. Our supplier has done a complete reinstall of the information on the PC. The reloaded copy of our website that is on the PC has changed. Many of the folder and file names which were previously in lower case are now in UPPER case - for example 'accommodation/index.htm and logo.gif' appear in the folder list as ACCOMMODATION/INDEX.HTM and LOGO.GIF' I changed a lot by right clicking and renaming - but it is a lot of files! I then opened our web in Frontpage and published it to my local web. This still left a lot of files listed in upper case including some that I had changed. Will this cause a problem if I publish the local web to the server? How do I get rid of the upper case? We are using Frontpage 2000 and the machine is Windows 98SE. It is also reacting slower and erratically since the reinstall so Norton has a lot to answer for Sarah Clyne Farm Centre Westport Avenue, Mayals, Swansea. SA3 5AR. Wales. UK. Tel: +44(0)1792 403333 Fax: +44(0)1792 403339 http://www.clynefarm.com Self catering and outdoor activities- home of the muddiest assault course in the world! Tag: photo gallery Tag: 46583
  - 5
    - back ground sound This is a multi-part message in MIME format. ------=_NextPart_000_0032_01C4CA34.31184200 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can you have FP put in background sound so that it will play on IE, = Netscape, and FireFox? I tried to do this by using the HMTL<bgsound/> = and then after that <embed/>. The sound played okay on the non-IE, but = on IE even though it was not looped it would loop and after the first = two loops it would start to overlap so that it was starting the second = loop a few seconds after the first one. Now I just have the <bgsound/> = so that IE plays it. Jim ------=_NextPart_000_0032_01C4CA34.31184200 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>How can you have FP put in background = sound so that=20 it will play on IE, Netscape, and FireFox? I tried to do this by using = the=20 HMTL<bgsound/> and then after that <embed/>. The sound = played okay=20 on the non-IE, but on IE even though it was not looped it would loop and = after=20 the first two loops it would start to overlap so that it was starting = the second=20 loop a few seconds after the first one. Now I just have the = <bgsound/> so=20 that IE plays it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV></BODY></HTML> ------=_NextPart_000_0032_01C4CA34.31184200-- Tag: photo gallery Tag: 46581
  - 6
    - Keep spammer from seeing my email addie in html code, how? I use a form on my website to have people send me email, but of course my email address shows in the html code used by the form. Although users cannot see the email address, I suspect some spiders/bots can scan through the html code and collect email addresses that way. 1) Is there any way to hide/mask my address in the html code? 2) Is there any way to hide all the html code in general to keep people from viewing it? (I think I already know the answer to #2 is "No'.) Tag: photo gallery Tag: 46579
  - 7
    - Net//Nieilsen Reports I copied this from the latest Nielsen//NetRatings Report but don't understand very much of it. Could someone tell me what Active Digital Media Universe, Current Digital Media Universe Estimate and especially, PC Time Per Person, mean ? I find it almost impossible to believe that an average home user spent 27:32:46 hours in the Month of October 2004 looking at Web sites! From this report it seems that the Internet population in the US hasn't increased much, if at all, since about 2000. Is that true? Thanks very much. United States: Average Web Usage Month of October 2004 Home Panel Sessions/Visits Per Person 32 Domains Visited Per Person 55 PC Time Per Person 27:32:46 Duration of a Web Page Viewed 00:00:53 Active Digital Media Universe 136,706,201 Current Digital Media Universe Estimate 199,861,345 Tag: photo gallery Tag: 46578
  - 8
    - How do I save and paste background music, not sounds? I have a classroom website, and a friend of mine was able to have music playing in the background of my homepage. I have tried numerous times to replace that music, but have been unsuccessful. I notice that it's saved under an mp3, but how do I actually save and paste it? Am I supposed to import it, first, snd then copy and paste it? However, what is weird, is I tried other pages I have on my website with background music, and when I save it or preview it, the music comes out perfect, but only works on the computer I saved it under. When I try my website on another computer, you cannot hear the music whatsoever. Someone please help me. The music benefits my students. Tag: photo gallery Tag: 46577
  - 9
    - Why do I not have links for Acrobat I have Acrobat 6 professional and I did have links on my Word XP to convert to a PDF file. I still have the links in Excel but not in Word. When I start Acrobat and try to convert a file to a PDF from Word it will not not convert. It opens the word file but that is all it does. Dave Tag: photo gallery Tag: 46572
  - 10
    - Page Width What is now considered the optimum page width to accomodate the various screen resolutions? Thanks. Tag: photo gallery Tag: 46566
  - 11
    - Force Downloading of File Does anyone know a simple way by using HTML-based links to force download a file? My hyperlinked WinZip files work this way. I would like my AutoCAD files (dwg) to work this way instead of embedding it in my browser. I would perfer when the hyperlink is clicked it prompts the IE6 "file download" applet to download to my harddrive. I'm not sure how IE6 goes about interpreting these file extensions. Is there some HTML code to disable this when this page or hyperlink is being accessed to force it to go to the IE "file download" popup? I use FrontPage 2003 and my server is window based (microsoft web hosting). Tag: photo gallery Tag: 46557
  - 12
    - Graphic resizes itself I have a graphic that sometimes will compress itself 50%. Refresh the page and it goes to normal. Does about 25% of the time. It is a gif file. Is there a way to keep it from doing this? Thanks, Mike Tag: photo gallery Tag: 46556
  - 13
    - FP 2003 Photo gallery slide show will not insert. FrontPage 2003 Photo gallery slide show or other galleries will not insert into webpage template. System is Windows XP Home. When I get the final option Progress Dialog box it starts to load the thumbnails for the Photo gallery then stalls at the end. So I cannot enter any of the photo galleries into FrontPage. I tried to change Authoring JavaScript/Jscript as mentioned in Article 828894 but the button is grayed out. Any help would be greatly appreciated. -- Regards, Wayne Tag: photo gallery Tag: 46555
  - 14
    - deleted border denies access to whole site! Help! In trying to delete a right-hand frame that appears on all the pages, I found a file on the staging server called "borders". In it, an html file said that all the pages would show the info on that page in the right border. Bingo. So I deleted the file. Now, I can't get into ANY PAGES on the site at all. I get an error message saying that there are no files under the main folder (in reality there are lots). What can I do? Tag: photo gallery Tag: 46554
  - 15
    - AllWebCo templates Folks, I purchased a web template from AllWebCo and anytime I edit a page with FP 2003 and save it, the link from the DHTML menu appears to be broken when I test it with IE. I was unable to import the entire web site into FP, I was just editing one of the pages. AllWebCo seems lost when it comes to FP 2003. I looked at both the menu program (javascipts) and before and after version of a page I changed with FP. I didn't see anything "screwy" that might be tripping this up. If I edit the pages with Notepad, it works out. I'm assuming the saved pages either are in a different format or that all "simple HTML" pages (AllWebCo's description of their code) cannot be edited in FP. Which, doesn't sound quite right. Any thoughts would be appreciated ! Bob Tag: photo gallery Tag: 46553
  - 16
    - Publish without "delete file on server" query? I'm using FP2000 to maintain a .org web site that's hosted by earthlink's servers. Whenever I publish changes to the web site (daily), FP sees all the hosting files that track visitor traffic and other things and for each one asks me, for example: "the file logs/.htaccess exists on the server but does not exist in the current web. Would you like FrontPage to remove it from <Root Web>?" I have to click "no" for each one (currently about thirty such files). I'd love to find a way to stop FP from comparing files on the server to files on the web on my C drive when I publish. Don't want to delete the files from the server, either, nor copy them to C: as they are apparently being added daily as traffic is tracked. I know I can just upload changed pages with FTP outside FP, but if FP's publish routine can be tweaked I'd appreciate knowing how. Thanks. Tag: photo gallery Tag: 46546
  - 17
    - Why are pages background losing colors and more... I recently upgraded to Frontpage 2003 and have only one problem so far. In Frontpage 2000, almost all of my pages page properties were "borrowed" from another page. I can't figure out how to change the properties of these pages as they now appear locked without the option of browsing other pages as I had done before. Also, when I am publishing, several times I have had entire folders of these pages "lose" their background color as well as their font color and they become plain white and black respectively. What's going on? Tag: photo gallery Tag: 46539
  - 18
    - .ra background sound I've added an .ra sound file to my website page through "page properties' and "background," yet the file will not work. In Frontpage 2000, I have saved the embedded file yet still nothing. Am I omitting something? Tag: photo gallery Tag: 46536
  - 19
    - Front Page Background issues I keep trying to place a new background on my web pages, but it keeps coming up with: Server error: Invalid character in web name "/C/Documents and settings/My Documents/My Webs":(0x27) Does anyone know what is the problem? I am running Office 2000 premium with Office Xp, I have tried to uninstall them but for some reason Front Page cannot be removed! Can anyone help please! kut'luch Tag: photo gallery Tag: 46535
  - 20
    - Server Extensions Anybody know when I can FrontPage 2000 Server Extensions for Windows Server 2003? Thanks, Kevin. Tag: photo gallery Tag: 46532
  - 21
    - Link bar is hidden under web site banners? I cannot see my link bar when I publish my web site. What html code will reveal my link bar from behind an ad banner? Tag: photo gallery Tag: 46524
  - 22
    - Updating a datetime field in SQL Server Updating from a form: (FP2003/SQL 2K SP3) Have tried this many ways: update SVC00200 set srvstat=::Status_set::, Arrivdte='::ArrivedDate::', ArrivTme=''1900-01-01'+' '+::ArriveTime::', CompDte='::CompDate::', CompTme='::CompTime::' where callnbr='::Callnbr::' update SVC00200 set srvstat=::Status_set::, Arrivdte='::ArrivedDate::', ArrivTme='::ArriveTime::', CompDte='::CompDate::', CompTme='::CompTime::' where callnbr='::Callnbr::' update SVC00200 set srvstat=::Status_set::, Arrivdte='::ArrivedDate::', ArrivTme=::ArriveTime::, CompDte='::CompDate::', CompTme='::CompTime::' where callnbr='::Callnbr::' ArrivDte and ArrivTme are datetime fields in SQL Server. This is for a website doing remote updates to an application database so I cannot change the field types. Don't ask me why they keep the date in one field and the time in another. Anyway, I can update the date just fine, but get various errors updateing the time from a form: Syntax error converting datetime from character string You should provide default values for all form fields that are used in the query. Depending on how I've got the above code written. The default for both fields is 1900-01-01 00:00:00.000. A straight update statement works fine: update svc00200 set arrivtme='3:00 PM' where callnbr='0000031083' and updates the arrivtme to 1900-01-01 15:00:00.000 Any help is appreciated. Tag: photo gallery Tag: 46522
  - 23
    - Need some Frontpage and Login Page Help Hi i basically posted everyone on google groups trying to get some help. I have a intranet webpage that will have some pages online the school I work for want to be able to have there students be able to go to our servers and download there homework and have a default html page with there test scores and other info. Creating the HTML pages and the server will be no problem. Here is my problem tho, I need a login page for each grade (K-8) and now when a student enters there name and password (which will be given by the school) they will automatically be sent to there default index page. Now someone told me I can just make a database using Access 2000 and enter the userid,password, and have URLredirect in the Access 2000 Database, ok I will do that, BUT I dont know how to connect the database and frontpage together so that the login page can read the database. I am mostly familiar with simple html codes. I am not a complete novice, but then i am not a pro. Any help would be great. Tag: photo gallery Tag: 46521
  - 24
    - Front Page freezes I am using Office 2000 on Windows XP. FrontPage opens fine, and when I choose to open a web/file, the pull-down menu comes up fine. But when I click on the web/file I want to open, the program freezes. I've been using this program for a few years now, and this has never happened until this past week. I did a sytem restore, that did not help. Any suggestions on how to get FrontPage working again, without uninstalling and Reinstalling Office 2000? Thanks, Rob ____________________________________________________ "if someday you wake up and find what you make up, come and get me, come and take me there. Into your illusion I'll make my intrusion, anytime, anyplace, anywhere." - Soul Asylum Tag: photo gallery Tag: 46520
  - 25
    - FTP-File download Sorry for my lack of knowledge- Using FP 2002 I want to place a file (zip format - since the file is 24Mb unzipped) on my web site so a friend may download it.- i.e. save it to their PCs insteafd of having to mail a disk. Could someone tell me the basics of doing this? The help in FP doesn't seem to cover FTP or download Tag: photo gallery Tag: 46509
- Next
  - 1
    - Access database and frontpage I am new to using Frontpage and Access and would like some advice. I have created an intranet site fro the school no problems, but I have also created a database to keep track of the ICT rooms and their bookings. The data access page I have incorporated into a front page page and it works well run locally as it picks up the database from my machine, but when I publish it to the server I get the form but not the information conatined within the database. I get the message abou needing to install web componants, but I cannot find them anywhere. Help please, before I go any greyer. Tag: photo gallery Tag: 46504
  - 2
    - now you see it now you don't I have developed a few web pages and have noticed that when previewed in Front page 2003 the page displays the gif (picture) as well as the link but after uploading to the hard drive and viewed on the net the picture does not show yet others which are handled in the same way do? Any help would be greatly appreciated. Steve Tag: photo gallery Tag: 46503
  - 3
    - Database results wizard query Hi, I'm using the database result wizard to extract information from a Access database. The wizard allows you to enter critera at the top ASP page once it's created it. If I create a separate HTML page as a 'critera entry' page, how do I pass the information from the HTML page to the ASP AND then pass it into 'webbot' that runs the SQL statement ? In the HTML page, I call the ASP with the following command: List.asp?PR=Rooms=2 The ASP page, get the data passed with the following bit of script: <%session.LCID = 2057 Room_No=request.querystring("Rooms") %> In the webbot command, I have the following SQL statment in the s-sql field: s-sql="SELECT * FROM SOL_Voidlist WHERE (Rooms=' & Room_No & ')" If I this, it seems that the webbot command complete ignores the value in the Room_No field. If I amend the SELECT statement and type the value directly, it works OK ! Can anyone let me know what I'm doing wrong and why webbot ignores extrnal values held within a field ? Thanks for your help in advanced. Regards, Nick Tag: photo gallery Tag: 46500
  - 4
    - Help with FormMail My feedback form worked great until I had to move my whole site into its own subweb to add a second one using the same domain. Now FormMail won't work. It sends me the results, but won't redirect the user. (at least is was sending me the results.. I'm not so sure now). I've tried putting a cgi-bin folder with FormMail in the same directory that I moved the site to and where the html forms are, but that didn't work. I'm thinking that the problem is simply that I haven't told FormMail its new path, but I can't locate anyplace to do that. I believe I've used the #Redirect syntax correctly. I copied it, added it under the #Redirect line and changed the web address to the location of the "thanks" form. Any help would be appreciated. If it helps, the form is located at www.dynamicsports.net/cycling/feedback.htm Thanks. ~Marlon Tag: photo gallery Tag: 46497
  - 5
    - Form messes up table width? This simple WEB has a Nav bar on the left. All the pages work OK except for one which has a FORM on it. For some reason the width of the Nav Bar table cell has shrunk!! Any ideas how to fix this? http://www2.whidbey.net/bobr/Poker/Register.htm Tag: photo gallery Tag: 46489
  - 6
    - Put audio/video on Frontpage How come you can't easily put audio on Frontpage? I want to put a button so people can click on it to hear what is on that particular page. Also, how can you easily put video on Fontpage? It's stupid that you can't do either of these things easily! The web took off when pictures could be shown. Isn't the next logical step to have audio/video on web sites? Tag: photo gallery Tag: 46478
  - 7
    - Editing Database Results Error Messages The error messages are pretty vague for errors in database results pages. Is it possible to replace these messages with one of my own design? For example, if someone attempts to enter data in a form without creating their own UserID, then they get this message: "Error Description: [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'UserIDs'." Thanks Tag: photo gallery Tag: 46477
  - 8
    - Custom Control for FP 2003 Hello FrontPage Newsgroup, I would like to make a "custom" control to use on a FrontPage generated ASP page (perhaps it could be called a DTC). My concept seems simple: it will have two drop downs, one populated from a table in a database, and the other populated from a date (2 dates, today and tomorrow), and a text entry field for the time of day, and a button to submit the data. My asp page will have 3 of these "control", I thought rather than place a bunch of ddwns, and text boxes on the page, I would make 1 or 2 "controls" that would be usable else where. Does this make sense? What tool should/can I use to do this. I wish I could develop this page using ASP.NET, but the page needs to support an existing all ASP web site. Any suggestions will help. Thank you, eric Tag: photo gallery Tag: 46472
  - 9
    - Has anyone used Form Processor Pro from MitriDAT? Has anyone tried this software? For servers without ASP (but offering PHP), this software is advertised as capturing form post data and routing it to email and/or db (mySQL, csv) without the need to create custom PHP scripts. If it works as advertised, it would be well worth the $29 cost for me. However, I'm hesitant to try it without hearing an independent evaluation. Software is offered at: http://www.email-form.com Thanks for any input! Jim Tag: photo gallery Tag: 46471
  - 10
    - Frontpage opens new windows Hi, When I click on hyperlinks in my Web Site, new windows are opened, but I only want one window that I can navigate back to with the back button. How can I do this? Thanks Tag: photo gallery Tag: 46469
  - 11
    - Macro for commenting out columns in table Hi everyone! I would like to write a macro that comments out certain columns in a table Input: <table> <tr> <td>col 1</td> <td><a href="col2">col 2</a></td> <td>col 3</td> <td>col 4</td> <td>col 5</td> </tr> </table> output: <table> <tr> <td>col 1</td> <td><a href="col2">col 2</a></td>  </tr> <tr> [...] </tr> </table> I'm new to Visual Basics but a handy Java programmer. How would a go about? Is there any regexp library I would use to find the desired columns? If someone can give me a code snippet to start working with, to sort of kick me in the right direction, I'll figure the rest out. Many thanks /Karl Tag: photo gallery Tag: 46462
  - 12
    - Help writing a macro One of the things I have to do repeatedly is to reformat text in a manner that is more appropriate to code. I'd like to automate the process in a macro but I am having a little trouble figuring out how to do it. Here's the sequence of events I'd like to accomplish: Search forward for a new line. Select the new line characters. Replace the new line with a carriage return. Assert a shading of light gray. Assign a font of Courier New, 12 pt to the paragraph. In Word, this was dead simple and I thought I could just copy the macro over to FrontPage. However, that didn't work because the FrontPage VBA didn't recognize all of the Word VBA objects. This is the macro from Word that replaces the carriage return with a new line. It fails in FrontPage. Sub LineBreakReplacesParagraph() ' ' LineBreakReplacesParagraph Macro ' Macro recorded 2/29/2004 by Richard Lewis Haggard ' Selection.EndKey Unit:=wdLine Selection.TypeText Text:=Chr(11) Selection.Delete Unit:=wdCharacter, Count:=1 End Sub Any suggestions on how to make the macro work in FP 2003? -- ---------- Richard Lewis Haggard Tag: photo gallery Tag: 46448
  - 13
    - Opening page no address or tool bar. When linking to a secure page, how to I keep the opening page from having an address bar and tool bar? Thanks, Mike Tag: photo gallery Tag: 46443
  - 14
    - 2 Problems - Edit and Editor Hello. When I try to edit I using the database editor I get this message: Database Results Wizard Error Description: Syntax error in UPDATE statement. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engine One or more form fields were empty. You should provide default values for all form fields that are used in the query. I simply want to add the tray number field and this comes up. What can I do? Problem 2# How can I, on the top page of the database editor, make the add new record button go to submission_form.asp instead or new.asp? Thanks for your help. RJP My site is www.catalanooptics.com. user name is catalanoopt and pass is LG123 Tag: photo gallery Tag: 46442
  - 15
    - How do I create ecards for my website? I wanted to offer my customer the option of sending a free ecard to their friends. Since I sell art, I wanted to let them choose from a variety of portraits and then attached their personal message. I am using Front Page 2003. Tag: photo gallery Tag: 46438
  - 16
    - Lost Personal Web Server! Greetings, I cannot access my personal web server, Can anyone tell me how to put it back into my system, or run Front Page with out it! I am currently using Office 2000 Premium with Office Xp on Windows Xp Pro Tag: photo gallery Tag: 46435
  - 17
    - WIndows User ID Is there any way for Front Page to get the network ID of the user that opens a page? Tag: photo gallery Tag: 46434
  - 18
    - Changing size of slideshow thumbnail arrows I would like to make the arrows that appear on both sides of the thumbnails in the slideshow larger - more visible. Getting many complaints that people cannot see them at all. Please help! Tag: photo gallery Tag: 46429
  - 19
    - fill form field from querystring Want a simple way of having a value from the querystring that opens a page be included in a hidden field of a form. In ther words the form would be called by a URL like ..../Satisfaction.htm?job=JobName and then the value of the job would be put into a hidden field so it would be sent out with the e-mail from the save results component. I would prefer the simplest solution so that the end-users can self-maintain Tag: photo gallery Tag: 46426
  - 20
    - Updating a datetime field (SQLServer) from a form Updating from a form: (FP2003/SQL 2K SP3) Have tried this many ways: update SVC00200 set srvstat=::Status_set::, Arrivdte='::ArrivedDate::', ArrivTme=''1900-01-01'+' '+::ArriveTime::', CompDte='::CompDate::', CompTme='::CompTime::' where callnbr='::Callnbr::' update SVC00200 set srvstat=::Status_set::, Arrivdte='::ArrivedDate::', ArrivTme='::ArriveTime::', CompDte='::CompDate::', CompTme='::CompTime::' where callnbr='::Callnbr::' update SVC00200 set srvstat=::Status_set::, Arrivdte='::ArrivedDate::', ArrivTme=::ArriveTime::, CompDte='::CompDate::', CompTme='::CompTime::' where callnbr='::Callnbr::' ArrivDte and ArrivTme are datetime fields in SQL Server. This is for a website doing remote updates to an application database so I cannot change the field types. Don't ask me why they keep the date in one field and the time in another. Anyway, I can update the date just fine, but get various errors updateing the time from a form: Syntax error converting datetime from character string You should provide default values for all form fields that are used in the query. Depending on how I've got the above code written. The default for both fields is 1900-01-01 00:00:00.000. A straight update statement works fine: update svc00200 set arrivtme='3:00 PM' where callnbr='0000031083' and updates the arrivtme to 1900-01-01 15:00:00.000 Any help is appreciated. Tag: photo gallery Tag: 46424
  - 21
    - Forms without using ASP I'm sure this has been addressed before, and I apologize if I haven't found the previous answers. OK, if your server supports FrontPage 2002 extensions, but doesn't support ASP, what do you need to create input forms? Do I need to train myself in a new scripting language, like CGI? How can I simplify form creation and collection of data without ASP? I have a server that says it supports FrontPage functions, like forms, collecting info to db, and others, but it DOES NOT support ASP, and I'm at a loss as how to set up the form. Tag: photo gallery Tag: 46423
  - 22
    - Fill Drop-Down With Query Using FP2003 on XPPro, site hosted on WIN2000 Server, IIS6, Access 2003 database. Is there any way to fill the selections of a drop-down box from a query? I'm writing an application that has 40+ entry forms, each of which uses a drop-down. I can't see any way of filling the values with a query, and entering them individually will become an administrative nightmare. Thanks Tag: photo gallery Tag: 46421
  - 23
    - To stop others from copying pictuers from my web site How do I stop someone from copying pictures from my web site Tag: photo gallery Tag: 46414
  - 24
    - editing html but reverts back to original FP2000 I'm editing the html in a dbrw page -- want to change the name of the query. But after I save the changes it reverts back or stays the same. I even used notepad to make the changes. Any ideas? Thanks. Tag: photo gallery Tag: 46413
  - 25
    - Problem with SQL-Server Constraints and Frontpage I am using a Frontpage Applikation to Save a form to a SQL-database. That works so far. My database has a foreign key constraint on the table where th form inserts its Data. An if the inserted data conflicts with that constraint it does not get inserted. So far just as it should bee. The only problem is, that even in the case the insert fails, because of the constraint, my application goes to the success URL and not to the fail URL, as I would expect. Server is a Microsoft SBS 2003, with FP-extentions enabled on the Web belonging to this Project. Any hints for me? tia Markus Tag: photo gallery Tag: 46411

I want to put the file name of the current main picture in photo gallery into
a form field that will be displayed on the same page. Any ideas??

Re: photo gallery by Jens

Jens
Mon Nov 15 10:07:46 CST 2004

This is a multi-part message in MIME format.

------=_NextPart_000_003C_01C4CB35.A0E8C0D0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

You must create your own Photo Gallery for this.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

> -----Original Message-----
> From: Alan Smith [mailto:Alan Smith@discussions.microsoft.com]
> Posted At: 15. november 2004 12:54
> Posted To: microsoft.public.frontpage.programming
> Conversation: photo gallery
> Subject: photo gallery
>
>
> I want to put the file name of the current main picture in
> photo gallery into a form field that will be displayed on the
> same page. Any ideas??
>

------=_NextPart_000_003C_01C4CB35.A0E8C0D0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7036.0">
<TITLE>Re: photo gallery</TITLE>
</HEAD>
<BODY>


<P><FONT SIZE=3D2>You must create your own Photo Gallery for =
this.</FONT>
</P>

<P><FONT SIZE=3D2>Regards Jens Peter Karlsen. Microsoft MVP - =
Frontpage.</FONT>
</P>

<P><FONT SIZE=3D2>> -----Original Message-----</FONT>

<BR><FONT SIZE=3D2>> From: Alan Smith [<A =
HREF=3D"mailto:Alan">mailto:Alan</A> Smith@discussions.microsoft.com] =
</FONT>

<BR><FONT SIZE=3D2>> Posted At: 15. november 2004 12:54</FONT>

<BR><FONT SIZE=3D2>> Posted To: =
microsoft.public.frontpage.programming</FONT>

<BR><FONT SIZE=3D2>> Conversation: photo gallery</FONT>

<BR><FONT SIZE=3D2>> Subject: photo gallery</FONT>

<BR><FONT SIZE=3D2>> </FONT>

<BR><FONT SIZE=3D2>> </FONT>

<BR><FONT SIZE=3D2>> I want to put the file name of the current main =
picture in </FONT>

<BR><FONT SIZE=3D2>> photo gallery into a form field that will be =
displayed on the </FONT>

<BR><FONT SIZE=3D2>> same page. Any ideas??</FONT>

<BR><FONT SIZE=3D2>> </FONT>
</P>

</BODY>
</HTML>
------=_NextPart_000_003C_01C4CB35.A0E8C0D0--