fill form field from querystring

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
    - 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: fill form field from querystring Tag: 46424
  - 2
    - 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: fill form field from querystring Tag: 46423
  - 3
    - 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: fill form field from querystring Tag: 46421
  - 4
    - To stop others from copying pictuers from my web site How do I stop someone from copying pictures from my web site Tag: fill form field from querystring Tag: 46414
  - 5
    - 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: fill form field from querystring Tag: 46413
  - 6
    - 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: fill form field from querystring Tag: 46411
  - 7
    - how do I lock the page I designed so it doesn't change when viewe. How do I lock the page so it doesn't change when viewed on line. The text keeps changing and moving around. I want to lock it so the text doesn't move around. Tag: fill form field from querystring Tag: 46407
  - 8
    - Video viewing and Forced Form Completion I would like to have students view a brief video and then force them to complete a form indicating that they have viewed the video. However, I only want the form available after they've viewed the video. Is this possible? and How? Tag: fill form field from querystring Tag: 46404
  - 9
    - Forcing to a form after viewing a video clip I would like to redirect the viewers of a video to a form after the completion of the video clip. I also want to make sure that they watch the entire video. How is this possible? Tag: fill form field from querystring Tag: 46403
  - 10
    - redirect after form submits results to email I think this should probably be an easy question, but I can't figure it out. How do I redirect to another page after a form has been submitted using the Send to email address form property?? I tried setting the second page to a confirmation page url but that doesn't work. It submits the form on the second page instead of displaying it. I've tried the hidden field redirect, but that's not working either. I'm the onsubmit= but it's not saving the value after it's published. It defaults a FP confirmation page. Can this be done?? Here's the form submit code: <form method="POST" action="--WEBBOT-SELF--" onsubmit="location.href='../_derived/nortbots.htm';return false;" language="JavaScript" webbot-onSubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1"> <strong>[FrontPage Save Results Component]</strong><p align="center" style="margin-top: 0; margin-bottom: 0"> TIA! Tag: fill form field from querystring Tag: 46399
  - 11
    - database and email forms results with DRW Dear Mr Buyens: I am repeating my enquiry here in case my question/submission as part of the "Aug/12 Dave" ADM thread fails to raise an issue. Dear Mr. Buyens Have tried the code suggested herein (as indicated in another part of this thread), but I cant get the filed values to pass in the email, since I donâ??t know how to "intercept" the "on submit" action of the DRW webbot. I have purchased a copy of your FP03 Inside/Out book in the hopes that it would reveal how to do this ... but no joy. I include a copy of my situation from the other thread here: ------ copy ---------- I am trying to do something similar (results to both mdb and email). The interlacken code had to be modified since my ISP doesn't support CDO's, and so re-wrote it for ASPMail, and I've had to remove the "IF" construct (possible for relating to my speculation below) However, the email sends "blank field values". In my case the form/db etc are created using FP03's DRW etc. I am not sure if the webbot/onsubmit script etc is somehow intercepting the field values (including the submit button) and preventing that data to be available (e.g. not only is does the email not include the data, but also the IF construct fails since there appears to be no value in the button variable). I have tried various permutation of the email code on the form page, as well as on the confirmation page. In all cases, the best result is that an email is issued (whether or not the submit button is pressed), and the field values are null. Please advise. -----end copy ------ Tag: fill form field from querystring Tag: 46394
  - 12
    - Page Titles How can I get the page title to stay the same name (My Business) while having each link go to a different url? Home Page About My Company Offers Contact Us Etc. Thanks. Tag: fill form field from querystring Tag: 46385
  - 13
    - Template or sample web site? Hi, I'm just starting up and would like to look into a couple of samples/templates for a general business web site, before I start modelling our own! So, in general I'm looking for a sample containing the following: 1) Short presentation of the company 2) Presentaion of the working force 3) Presentation of services/products offered 4) Road map explainig the location etc. Any help/reference are appreciated... Rgs, /Kjell Tag: fill form field from querystring Tag: 46383
  - 14
    - Text Orientation I have an HTML table with some text in it. How do I get the text to be written vertically ie you have to turn you head 90 degrees to the screen to read it. ie in stead of reading right to left you are reading bottom to top. I'm sure its just a style - but I cant find what Thanks Tag: fill form field from querystring Tag: 46380
  - 15
    - Beginning Question I just upgraded my machine from XP Home edition to XP Professional. So where is my IIS? Is there a good web site that tells you steps needed to create a web presence using Microsoft products? Tag: fill form field from querystring Tag: 46374
  - 16
    - IIS6 Nortbots error I'm trying to move a web site from a Win2K server to a Win2K3 server. I use FP2K to publish to both servers. Search forms that work on the the 2K server don't work on the 2K3 one and give me a 404 error with "server/web/_derived/nortbots.htm" not found. Everything I've found so far refers to an issue that was resolved many releases of FP extensions ago. Any ideas? Tag: fill form field from querystring Tag: 46360
  - 17
    - force a cell to contain a fixed number of rows I've got the original FPX (I think) that comes with Win98 (ver. 2.0.2.1118). Is there any way to force a cell to contain a fixed number of rows? There is a setting for cell properties that allows you to change this (number of rows spanned) but when I set the number of rows to more than 1 it moves the cell below over into another column (???). Thankx --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 11/1/04 Tag: fill form field from querystring Tag: 46359
  - 18
    - password protected area I nees to create in FP an area protected by paswords. Who could tell me a code of asp, and the instructions to get it work? Thanks Tag: fill form field from querystring Tag: 46356
  - 19
    - Frontpage E-Mail Message Header subject line When using Front Page to compile an on-line form for e-mail submission, is it possible to define the email subject header with predefined text and text from one of the from fields. For example, i'm aware you can choose the predifed text by placing this with-in FORM PROPERTIES then OPTIONS and EMAIL RESULTS then placing hte predefined text with-in the e-mail message header subject line, or ticking the Form Field Name and then placing the Field name in the box instead, but is it possible to use a combination of both. So if someone places their name into one of the Form Field entitled NAME then when you receive a submitted form by email the header will read something like ENQUIRY FROM 'NAME'. Can anyone help?? Many thanks, Steve. Tag: fill form field from querystring Tag: 46355
  - 20
    - Images not displaying in DBRW I'm using the db results wizard in fp2000. I have a text field in the table with the path to the image in the text field. The results display the path (the contents of the text field) and not the image. Oh, the folder in the web for the db and the images are on the same level. I have "images/imagename.jpg" in the text field. Is this the way to do it or what do I need to change? Thanks. Tag: fill form field from querystring Tag: 46346
  - 21
    - Include Statement I have been using the include function for awhile now, and it is great... BUT yesterday we moved to a new server which is an Apachie (SP) now none nothing works... I have tried  and it does not pick it up. The only way I have been able to make it works is to move the include file to the main directory. This would be ok if it were only one or two files but it is many, many, many files.. Sure hope someone has a great answer. Thanks Tag: fill form field from querystring Tag: 46337
  - 22
    - Images Some of my images are not showing in frontpage I have tried saving them as jpeg and gif files but the problem still occurs. I can view them all in normal view but only some in preview. a box appears with the x in the corner, when I right click on this and select the show picture option it still will not show. Sometimes the show picture option is not available Tag: fill form field from querystring Tag: 46332
  - 23
    - Hit counter When I add a hit counter to the bottom of my page It will only say hit counter and nothing else happens. How do I fix this Tag: fill form field from querystring Tag: 46331
  - 24
    - hit counter Tag: fill form field from querystring Tag: 46330
  - 25
    - Images Some of my pictures are not showing in the preview screen. I can view them in normal screen. I tried using the same picture format jpeg but didn't work so changed them all to Gif but still not all images showing. I just get a box with an x in the corner. If I right click on this go to show picture nothing happens. Sometimes the show picture option does not appear Tag: fill form field from querystring Tag: 46329
- Next
  - 1
    - Pictures in Db Results I would like a picture to show up for each record in the DBRW. How do I set this up? I know how to link a picture to a record in ms acces but not sure how it works in the dbrw. Thanks. Tag: fill form field from querystring Tag: 46325
  - 2
    - Incorporating theme and ASP Hello, Using FrontPage 2000, I started building a web site with a theme (I went through the wizard originally). Using the wizard gave me a specific set of pages. Navigation screen shows the hierarchy of these pages. Now, I would like to replace Default.htm (which was created by the wizard) with Default.asp so that I can use ASP code. I'm finding that FrontPage is not letting me replace Default.htm with Default.asp and still retain the same hierarchy. [i.e. On Navigation page, I drag the pages connected to Default.htm and try to place them under Default.asp, but it's not happening.] What can I do? Thanks a lot. Tag: fill form field from querystring Tag: 46324
  - 3
    - java script I'm having trouble with a sound javascript. It has to be a problem with the coding. It will work in IE but not in NS. The page is. http://www.marinemammalstrandingcenter.org/test4.htm Tag: fill form field from querystring Tag: 46323
  - 4
    - frontpage results from excel database Can anyone help please? Perhaps I phrased the SUBJECT line incorrectly so I have copied the original problem & some subsequent developments into this new thread. Thanks Michael >>-----Original Message----- >>I wish to enable a search facility on my site so users >>can search a product list. But the result does not >>display any records or show "no records found". >> >>I followed this article which appeared in an earlier >>thread dated 4/10/04, >>http://support.microsoft.com/default.aspx?scid=268948 > >>and set up a new connection from scratch - but the issue >>remains. >> >>When I first tried the search this message appeared, >>Method Not Allowed >>The requested method POST is not allowed for the >>URL /productsearch.asp. >> >>so i change the method to GET and still nothing - not >>even the message of "no records found" >>I have saved the page as asp. My example can be seen >here. >>http://www.kleeneze-people.co.uk/productsearch.asp >> >>I use frontpage2000. >> >>Can anyone help please? >> >>Thanks >>Michael >>. >-----Original Message----- >I forgot to mention that I don't need to save the search >results anywhere. They just need to be displayed to the >user. > >Michael > Have made a bit of progress. I created a new page & a new database connection. Added one field (product code) as my criteria & saved the page I can input the search term (a product code) but the entire excel database spreadsheet appears instead of just the item I required. Frankly, I don't even know what I did to get THAT to work, but I went & added a 2nd field (description) to the criteria. Saved the page & uploaded it. However, when I do a search on that field, the entire database spreadsheet appears which I don't want. Advice appreciated please (before I lose ALL my hair ;-( Thanks Michael >> >. > . Tag: fill form field from querystring Tag: 46320
  - 5
    - Excel / Formula Direction Needed How do I take data from a table (columns of names and numbers) and write a formula so data from that table can appear in a specific cell or group of cells. Example (table contains three columns): Column 1 Truck # Column 2 Driver # Column 3 Driver Name (list of 15-20 rows for each column) How do I write a formula in A2 that will populate the truck # in A2 and their driver # in B2 and their name in c2? I don't need every piece of data from the table in consecutive rows. Sometimes I need the repeated in multiple rows. Tag: fill form field from querystring Tag: 46316
  - 6
    - Database Question I have a page on my web site for members to sign their info up so that we can keep in touch for any upcoming reunions. I've tried to have it saved in a Access file but my server does'nt allow "Global.asa" or member.asp files ,,is there anyway that i can get the information into a form other than text or html? All the ways that FP '03 allows in text and html comes across as one big rambling mess into my database and makes it hard as hell to figure out who's info is who's. Is there anyother way to get this info into a readable form?? Oh i've tried xml as well , but the server doesn't support this either it seems. Thanks,,, Oh one other thing ,, is there a way that i could have them fill the form out ,,all the very personal stuff like address email phone go straight into the database along with name grad year etc. but still allow the Names and grad year to show on a separate page??? I hope i'm making my intent clear ,,this is all new to me. Thanks again to all Gord Tag: fill form field from querystring Tag: 46315
  - 7
    - Dynamic Web Templates I'm applying a dwt to a page that contains several tables. After applying the dwt, the page looks fine in design mode. However, as soon as I save the page and preview it, the tables and formatting get all jumbled up. Is this something that frequently happens or something particular to what I'm trying to do? Is there a way to correct this? Thanks! Tag: fill form field from querystring Tag: 46310
  - 8
    - Frontpage Wizard error Utilized FrontPage 2003 Database Wizard to create an online feedback form. The Submission form indicates that everything transferred smoothly to the database. BUT. When I ask to see the results online or edit the database content I receive the following error. Database Results Wizard Error The operation failed. If this continues, please contact your server administrator. I've checked the ODBC connection on the server and nothing appears to be wrong. Any ideas? Dave Tag: fill form field from querystring Tag: 46309
  - 9
    - Guest book does not rediaplay data Hi is have tried all of the soultions offered for this problem. I can't find the "include page properties" ahoever, every thing else seems ok. I have looked at the guestlog.htm file and it apperas to be complete with all references. It is in the _privite directore and i have received no error messages. Any other suggestions?? The WEB site is www.bsausa.org/cfcpack74/bulow1004 select sigen guest log. Thank you in advance, Dick Tag: fill form field from querystring Tag: 46307
  - 10
    - changing font on banners in themes I am wanting to change the color and font of the letters in the banner of a theme. Is this possible? How thankyou Tag: fill form field from querystring Tag: 46303
  - 11
    - Help! I just normalized my database I'm one of those inexperienced database people who ended up with a d/b with 120 fields. I'm getting a lot of the "Too many fields defined" errors on update. I have researched and now know how to normalize my database. I have many tables now. My database is for customers to track there loan status. It has fields like.. name, address, date of app, lender, appraisal ord, appraisal rec, closing date set etc...... I can't figure out how to set up relationships in Access 2002. Each borrower wil will have a record in all tables. When I use the wizard to set up tables it asks will there be a record in the Borrower Table that matches many records in the Address Table or vice versa. It doesn't ask will there be 1 record in each table that matches 1 records in all the tables. Can someone please help me. I'm very frustrated! Tag: fill form field from querystring Tag: 46299
  - 12
    - Hit counter My hit counter is not shown at the bottom of the page it just says hit counter can I make this appear in any way Tag: fill form field from querystring Tag: 46293
  - 13
    - Images When I add images to Frontpage I can view the in noraml screen but not the prevew screen. I tried to insert them as jpeg files and gif files all that appeara is a box with the x in the corner Tag: fill form field from querystring Tag: 46292
  - 14
    - images When I add Images to Frontpage I can view them in normal screen but not in the preview screen. I tried these images as jpeg and gif files. All that appears is the box with the red x in the corner Tag: fill form field from querystring Tag: 46291
  - 15
    - Run batch file by clicking on button Is there a way to run a batch file by clicking on a button and supply the needed info for the batch file from a textbox? I have a batch file that requires info via %1. So I would like to create a textbox. When a user enters info into the textbox and the click on the button next to the textbox and batch file will execute and pick up the need info from the textbox. Is this possible and how? Or can it be done through another method? Tag: fill form field from querystring Tag: 46290
  - 16
    - Using Excel database I wish to enable a search facility on my site so users can search a product list. But the result does not display any records or show "no records found". I followed this article which appeared in an earlier thread dated 4/10/04, http://support.microsoft.com/default.aspx?scid=268948 and set up a new connection from scratch - but the issue remains. When I first tried the search this message appeared, Method Not Allowed The requested method POST is not allowed for the URL /productsearch.asp. so i change the method to GET and still nothing - not even the message of "no records found" I have saved the page as asp. My example can be seen here. http://www.kleeneze-people.co.uk/productsearch.asp I use frontpage2000. Can anyone help please? Thanks Michael Tag: fill form field from querystring Tag: 46289
  - 17
    - Where Can I Find Statistical Data on US Internet Usage Can someone please tell me where I can find current and past statistics about people in the US who are connected to the Internet from both home and work? I would like to find information on the number of people who are actively connected, how often and how long each session lasts, and it would help if I could find out how they are connected. I am trying to see how the Internet has grown since the year 2000 in the US. I would also like to find out many people/businesses have switched from dial-up to broadband. Thank-you. Tag: fill form field from querystring Tag: 46288
  - 18
    - ASP webbot Hi All, I put this question in a couple of days ago, but I haven't received posting on it. Could someone have a look for me please ! Using the Database results wizard in Front Page 2002, Iâ??ve created a standard database enquiry page. This works fine, but my ultimate goal is to create a complex SQL statement outside of this page, and insert the statement into the <!â??webbot procedure. This will give me greater flexiablity in creating a SQL statement from the critera entered by a user. I can create the SQL statement and pass it to a field within a ASP page. For simplicity, in the example below, Iâ??ve just shown part of my ASP page. Iâ??ve hard-coded the SQL statement in for this example. Iâ??ve created a SQL statement and put it into a field called TEST1. I want to be able to use this field inside the <!â??webbot against the S-SQL= item. No matter how I present the TEST1 field to the S-SQL statement, it will not use the value held within it. Iâ??ve tried ::TEST1::, <%TEST1%>, etc, nothing works. Iâ??m obviously not presenting the data incorrectly. Could someone kindly drop me some hints, as Iâ??m pulling teeth !! ASP script example: <% dim test1 test1="SELECT * FROM Sol_Voidlist WHERE bedrooms=2" response.write test1 %>  <% if 0 then %> <SCRIPT Language="JavaScript"> document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>"); </SCRIPT> <% end if %> <% fp_sQry="::test1::" fp_sDefault="" fp_sNoRecords="<tr><td colspan=25 align=left width=""100%"">No records returned.</td></tr>" fp_sDataConn="Academy_Live" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&propref=129&houseno=129&proadd1=129&heatcode=129&bedrooms=2&proptypecode=129&area=200&offers=2&diff_in_weeks=2&voidstart=135&keyretdate=135&relettarget=135&actrelet=135&udd15=129&voidaltkey=3&voidsuffix=2&voidtype=129&eventbi=129&eventbidate=135&eventfcas=129&eventfcasdate=135&eventffl=129&eventffldate=135&sfacode=129&freetext=200&" fp_iDisplayCols=25 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %> Best Regards, Nick Tag: fill form field from querystring Tag: 46286
  - 19
    - the word *********** types out like password in asterisks somehow, Frontpage 2002 captured a password I was changing with my webhoster. Now it only types the word as asterisks. I can't even type it here because will turn out the same way. Please help! Tag: fill form field from querystring Tag: 46280
  - 20
    - Database Results Wizard Error Created a database using Access- Used the Database Interface wizard in FrontPage - Having problems with database editor - database will not accept edits...brings up detailed record and accesses the edit page - but when saving changes the following error occurs: Database Results Wizard Error The operation failed. If this continues, please contact your server administrator. According to what I found out on-line "The reason for this is that the Timestamp field, which is mandatory in such a database, is a SQL data-type and must be enclosed in brackets if used as a column name in a database query." Did not find the "Timestamp" field within the update.asp page - changed all column names to include [ and ] - same error still occurs... ????????????????????? Tag: fill form field from querystring Tag: 46279
  - 21
    - web component problem I used a Frontpage 2002 web component to include an excel spreadsheet in a web page on my site. When i previewed it in my browser (IE 5.5SP2) it worked OK. After I published to my web hosting server it takes 20-30 seconds to load this page, which is about right. But then it just shows a little square with a dot in the middle where the spreadsheet component is supposed to be. The web hosting company supposedly support front page extensions. How do I get this to display correctly? Ron Tag: fill form field from querystring Tag: 46278
  - 22
    - Linking to JPGs on disk I need to link to some staff images stored on a hard disk using a database storing the path to the jpg file. Using vbscript I thought this would work: response.write "<p><img border='0' src='file:///strSource></p>" strSource being the path stored in the DB. Unfortunately when I preview this I get the dreaded red x and the path in the image property sheet shows as file:///strSource not file:///c:\folder\image.jpg or whatever the path is. I know this is my syntax as hardcoding the path works but I just cant seem to get it. Can anyone help? SHB Tag: fill form field from querystring Tag: 46275
  - 23
    - Having update problems with multiple Addresses for one Web-site We have 5 web site addresses that all go to the same web-site. The problem is when I change a page and go into publish it, everything goes well, then I go and check all of the addresses and a couple of them are not updating like the other 3? Any help would be appreciated. Someone suggested redirecting those web-site addresses to one main one? Can someone provide clarification for me please. thanks -- TIA Sheila Tag: fill form field from querystring Tag: 46270
  - 24
    - Force error message when database is missing Hello all, I have a FrontPage ASP file writing form data to an Access database on a different server. Everything works fine. But, if the backend database is missing for some reason (e.g. server down), and someone submits the form, they get a confirmation page and everything looks like it worked fine even though the data was lost. How can I force FP to return an error message if the database is missing, either when the user submits the form or, if possible, when the user initially loads the form? Thanks very much in advance. --Brian Tag: fill form field from querystring Tag: 46267
  - 25
    - Suddenly: Database Errors Abound Over the last 2 years I've developed quite a few ASP pages using the FP 2002 DRW to access and update 5 different database files, mostly .mdb files, with some .xls files. About 1 month ago, about 3/4 of these database queries started returning errors instead of data. I immediately surmised it was a hosting issue, and slogged through a lot of time with my host's tech support, reinstalling FP extensions, resetting permissions, removing, reinstalling, and updating FP 2002, all to no avail. After a couple weeks of telling me my code was faulty (funny, it had worked for the last two years just fine, and has not been modified), my host finally said their ODBC and MDAC components were corrupt, and that they reinstalled them with an updated version, but that now any query with a reference to a table that had a space in its name would fail. I dutifully changed the few table names and handful of queries I had against such tables, and things still failed in the same manner. Ultimately unsatisfied with the responses I was getting from the host, I finally changed hosts 2 days ago. The DNS got pointed to the new host's server yesterday, & I used FP to upload the site, only to find I'm still getting the same errors as on the previous host. The error messages I'm getting are all over the map, from "HTTP 500 - Internal server error " to "Database Results Error The operation failed. If this continues, please contact your server administrator." to " ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal." (This last message can be generated after correctly returning several columns of the first row of results.) The really weird thing about these failures is that other DRW queries against the same table are working perfectly!!! I've spent many hours poring over the code that FP generated, both code that works and code that fails, and it all looks fine to me. I've used the "compact and repair" function in Access 2002 on the database file, to no avail. The one semi-strange thing I noticed is the following entry in the global.asa file: <mso:connectionstatus msdt:dt="string">OSSCData_1=1 LibraryData=1 Events=0 Vendors=0 UploadedFiles=1</mso:connectionstatus> I would think that all values would be the same, since no connection was open to any of them that I was aware of. Does anyone have any thoughts on what might be broken? I'm getting desparate!!! Thanks in advance, A.D. Tag: fill form field from querystring Tag: 46264

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

Top

Re: fill form field from querystring by Stefan

Stefan
Tue Nov 09 03:16:43 CST 2004

See http://www.developer.irt.org/script/form.htm#10

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________

"Innovations" <Innovations@discussions.microsoft.com> wrote in message news:8150BD5D-21D3-42EB-9BCB-BA2F0F60795D@microsoft.com...
| 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

Top