variables

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
    - Microsoft VBScript runtime error '800a000d' Type mismatch: 'FP_FieldVal' I have a website containing forms that worked before I went on three weeks holidays, when I came back all forms that access data from an access database have the following error where the field from the database should be displayed: Microsoft VBScript runtime error '800a000d' Type mismatch: 'FP_Field' /Members_interface/Instructors/InstructorListing.asp, line 18 I have spoke to the web hosting technicians and they have re-loaded frontpage extensions and said it must be my problem Any help greatly appreciated Thanks Trish -- TRLG ------------------------------------------------------------------------ Posted via http://www.forum4designers.com ------------------------------------------------------------------------ View this thread: http://www.forum4designers.com/message404842.html Tag: variables Tag: 61313
  - 2
    - Database Navigation buttons not centered In Frontpage 2003, in the "Database results region", 4 buttons are inserted at the last row of the table to navigate in the database. The problem is that they are displayed at the top of the cell, they are not centered vertically in the cell. I tried to change that in the cell properties but nothing changed on internet browser. Can you help ? Tag: variables Tag: 61312
  - 3
    - format db results date field hi, i want to format a fp results db field "inicio=<%=FP_FieldURL(fp_rs,"inicio")%>" in a a date format like dd/mm/yyyy. can i change the database results region in a situation like this? Tag: variables Tag: 61309
  - 4
    - Shorter format for Date field from Access Hi, I'm using Frontpage 2002, Access 2002 and IIS 5.1 on my workstation. In the database I have a Date/Time field that I will present in a shorter format in Frontpage. I can't find another way to do it except with a SQL-statement. It works fine in Access and when i verify it in Frontpage Database Results properties but in the browser I get an error: Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Number: -2147217904 (0x80040E10) Source: Microsoft OLE DB Provider for ODBC Drivers My code looks like this: SELECT Ad_head.Date_Time, Ad_head.Picture, Ad_head.headline, Ad_head.Price, Ad_head.Category, Ad_head.hid, Format([Ad_head].[Date_Time] ,'d\ mmm\ hh:nn') FROM Ad_head WHERE (((Ad_head.Sellorbuy)="Sell")) ORDER BY Ad_head.Date_Time DESC; I have also tested without Order By, with the same result. Has anyone a clue?? Thanks very much JÃ¶rgen Tag: variables Tag: 61307
  - 5
    - update db hi i have this page where the user return after pay , that receives values that i store in variables. i would like to store this variables in a table in my db. how to write that code. Tag: variables Tag: 61299
  - 6
    - call my .dll from FrontPAge I have a .dll that when given a value it will return an encrypted key. I need to be able to call this function from FP. Can anyone tell me how I do this. I am using a form to get the relevent data I need and I wish to disply the encrpted result on the form for the user also. Any help is appriciated - Thanks in advance Tag: variables Tag: 61298
  - 7
    - Open Images I have a hyperlink to an image which opens to its own window. The image is larger than the screen size so normally shrinks to fit in whatever the window size is. Can I have the same link but the image to open at full size and you have to use the scroll bars to view the whole image. paul p.... Tag: variables Tag: 61287
  - 8
    - XHTML vs HTML I have been maintaining a web site for several years now. I am currently using FrontPage 2003. The company that owns the site hired a marketing firm who has told my client the site needs to be redesign using XHTML and HTML no longer cuts it. So I have 2 questions to the group 1- Is there any validity to their statement? 2- will FrontPage 2003 support XHTML? I don't see it as an option. Thank you g Tag: variables Tag: 61283
  - 9
    - Horizontel Scroll Bar I posted the question in a different manner earlier. Aplogies. Here is my questions: How can I get rid of a scroll bar on the bottom of the page (I use FP 2003). If you care, please have a look at http://www.gmcs.ch/Deutsch1.html you'll see what I mean. On some pages I have that unnecessary bar and others I don't without knowing why. Thanks for help, Richard Tag: variables Tag: 61282
  - 10
    - How do I insert a table in HTML which allows users to sort items? Tag: variables Tag: 61272
  - 11
    - Does Frontpage 2003 have security for its Form/data collection, SS -- Bg@102659 Tag: variables Tag: 61270
  - 12
    - Page Size Good Afternoon I use FP 2003. The actual pages on the site are standard size. Rather than have it align left, I have centered the pages to have a border left and right. On some of the pages, however, I have a scroll bar at the bottom, which I neither need nor like. How can I get rid of the scroll bar? How do I reduce the page size or whatever I need to do.... ? I'm sorry it's probably a dumb question. Thanks help, Richard Tag: variables Tag: 61267
  - 13
    - Cd based FrontPage sites I currently have a FrontPage Website based on a CD which we give to employees who want to work from home. The CD-based site takes them through the steps of RAS, ICA, VPN, OWA in the familiar website environment. We have since switched to SharePoint (WWS). Is there anyway to create a Disc-based SharePoint site? Otherwise we will have to maintain two sites to keep the status-quo. Thanks Jack Tag: variables Tag: 61263
  - 14
    - Changing navigation buttons for Database In the Database Results region, at the bottom, 4 buttons are automatically displayed (like: first, previous, next, forward). Is there a way to change this buttons ? to put text instead or a different image ? Tag: variables Tag: 61262
  - 15
    - how do I get pictures to scroll with a button? how can i get my pictures to change with the text by way of using a button. I can get the text to change but the pictures don't come up on button press. Tag: variables Tag: 61261
  - 16
    - Onclick behavior just got FP 2003 and while setting behavior, i can't seem to get the mouse or keyboard actions. i can get the page actions. seems like something is turned off - but i can't find it. the jump to is dimmed also. help best regards, fred Tag: variables Tag: 61253
  - 17
    - Local Disk WebSite Directories I have in my storage some mixed directories which where created by different tools like FP2000, FP2003,DreamWeaver, Interdev and simple Windows directories. How can I serach the directories with Windows Explorere and identify and or distinguish between the WebSIte directories and other regular Windows directories? Thanks in advance kalish Tag: variables Tag: 61251
  - 18
    - calendar I am using frames to on a page which has a calendar. there is a header which changes the month in the frame, and the calendar itself. What I want to do is change the calendar every month to reflect the current month. What I am doing now is going in monthly and changing the target....jan.html to feb.html, next month feb.html to march.html..etc My hope is that I will not have to manualy update. Any ideas??? thanks. current code: <HTML> <HEAD> </HEAD> <frameset cols="60" framespacing="0" border="0" frameborder="0"> <frameset rows="92,84%" framespacing="0" border="0" frameborder="0"> <frame name="top" scrolling="no" noresize target="tres" src="tresheader.html"> <frame name="tres" src="jan.html"> <noframes> <body> <p> this page uses frames, but your browser does not support them. </p> </body> </noframes> </frameset> </html> Tag: variables Tag: 61247
  - 19
    - using an excel worksheet with sql statement and frontpage Ok, im sure this is the most basic thing for you guys to answer but it has me completely stuffed. All Im doing is using the frontpage database wizard with my own excel sheet and some simple sql statements to pull required info into a table. However, as it is a price guide, I would really like every second line to be shaded. Is there a simple way to do this or is it quite complicated? I would appreciate any assistance with this matter. Tag: variables Tag: 61246
  - 20
    - How can I export info from table in Front Page 2003? I have my Front Pagened website completely designed, but I have my Application table designed to gather info and my Contact Us table that also gatherss information that I want both sent to my Email (Only the Info) when I submit the info through the interactive submit buttons. I went through the whole Front Page training course and I couldn't find anything that talks about this theme. I need help ASAP. Thanks Orestes 954-893-0961 786-522-1753 Fax: 954-893-6817 ogd7461@msn.com Tag: variables Tag: 61245
  - 21
    - Changing font size in linked navigation bar How do I change the font size in a button of a linked navigation bar for which I am using an existing sytle? I have tried to use the Theme - customise but this doesn't work if you are not using the theme for the page. I am using my own .gif file as a background and wish to insert a navigation bar with a font size of 14pt or 16 pt. Your advice is greatly appreciated. Kind regards Helen Tag: variables Tag: 61240
  - 22
    - How do i insert a auto refresh timer in Frontpage web? Dear Sir/Madam Is there any option using which i can insert a code in a webpage which refreshes itself after a specific interval, using Frontpage? Regards Rohim Uddin Tag: variables Tag: 61238
  - 23
    - Picture in database field In Frontpage 2003, I used the "Databse Results Wizard", it displayed all the fields I want. But 1 field called Rating has the values : 1 or 0 or -1. Instead of displaying these values, I would like that it displays a small icon (I made them already) showing a plus sign or a circle or a minus sign. How can I change a value of a field in a icon ? Tag: variables Tag: 61237
  - 24
    - Making a bulliten board any hints on how this is done Tag: variables Tag: 61235
  - 25
    - Setting-up required fields on Contact Page How do I set-up my contact page to make the consumer have to fill out either their phone # or email address. I'm trying to mail it a required field so that they can fill in one or the other. Any help would be appreciated. Thanks. Tag: variables Tag: 61232
- Next
  - 1
    - Retrieve data by latest date I have a page where the user needs to retrieve the latest updated file in a directory. I'm using FP2003. Is there some code that I can use that will tell the program when a user clicks on that link, instead of just opening a specific link, to go and check the directory for the latest update? I would really appreciate any help you can give me. Thanks, Tag: variables Tag: 61231
  - 2
    - Why doesn't Frontapage help designing an file upload with progress Why doesn't Frontpage offer or help design a file upload form with progress bar. Why is it that if we want this, we have to find other programs to do this. Will Frontpage or microsoft offer this on any upgrades or do we look for other software packages that will offer this. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=c762eb2a-57e0-46d6-bdd2-095f849325fc&dg=microsoft.public.frontpage.programming Tag: variables Tag: 61230
  - 3
    - pdf file to open in new window Good Day May I please ask your help for the following issue: I have created a web page and linked a pdf file. I don't want this file to open in the same browser, but rather have a new browers window open up. I amended the hyperlink property target frame to read new page, but no result. Thanks help, Richard Tag: variables Tag: 61226
  - 4
    - need pdf file in new window Good Day How do I get a linked pdf file to open in a new browser window? I have checked "new page", but to no avail. Please help. Thanks, Richard Tag: variables Tag: 61225
  - 5
    - Exporting Data Using Frontpage I there a function in frontpage that will allow me to export data in a text tab and comma delimited text file. Tag: variables Tag: 61218
  - 6
    - table and cells taskpane I can't get table and cell taskpane to activate. it is there bu everything is greyed out can't use any of the options. Does anybod know anything about this? TIA. Sonj -- onlysoniPosted from - http://www.officehelp.i Tag: variables Tag: 61217
  - 7
    - Pix to open separately Hi, I added some picture on my web site, made thumbnails and was hoping when you click on them they'd open in kind of a frame. However, they open in a browser window. Is there anyway I can do this differently? I use FP 2003. Many thanks, Richard Tag: variables Tag: 61216
  - 8
    - Displaying characters left in Text box I added a Form in Frontpage 2003 and the input goes into an Access database. I would like to add a script that displays in real time the number of characters remaining in a Text box. I found an example at http://www.dynamicdrive.com/dynamicindex16/limitinput.htm but I can't integrate it well in my page because their example speak of: <form name="sampleform"> while in Frontpage, I don't see a form name, I see this instead : <form method="POST" action="--WEBBOT-SELF--" onSubmit="">. Can you help ? Tag: variables Tag: 61212
  - 9
    - Editing web page from external site One of my client told me to design some pages which should be same like our external website. Their webpages are in PHP and I am not familiar with PHP. Is it possible me to take their one page and edit through FrontPage 2003? or What can I do to design other pages without re-designing layout, styles, color combination and other things? Is there is any easy or fastest way to do the same? Tag: variables Tag: 61210
  - 10
    - how do I edit menu buttons in set templates? I am new to FrontPage 2003 and I didn't find an answer to my question when I did a serach, so this is hoping someone out there can give me a quick and easy answer. I am using a standard 'Personal Template' when making my site, but need to change the title of some of the set menu buttons to the left on the screen. FOr example, I do not need a 'FAVOURITES' or 'INTERESTS' section, but want to rename them to ie 'MP3 LIBRARY'. I thought the answer was just as easy as right clicking on the one I wanted to change and then type the new one, but this was not an option and the frontpage help wizard couldn't really help me. Please help me!! Tag: variables Tag: 61208
  - 11
    - variable how can i put this code <input type="hidden" name="n_prereserva" value="<%=FP_FieldHTML(fp_rs,"n_prereserva")%>"> in a variable and request it later in the page. Tag: variables Tag: 61204
  - 12
    - Set margin size for a confirmation page. We use FrontPage forms to collect data from our members. I would like every user on our website to print the same confirmation page using the same margins etc (like a pdf file). How do I set up the confirmation page to print the same for everyone regardless of their individual printer settings. Thanks for your help! Pam,,, wjgaoffice@aol.com Tag: variables Tag: 61199
  - 13
    - Meta Tag Refresh Is there a way to have this Meta Tag Refresh ignored by IE6.0 or in a frame when a page havign this set loads? A property in IE I can set to false maybe? Tag: variables Tag: 61192
  - 14
    - FP2003 bug inserting Data View? Hi all When i insert a Data View into a web site, and i select a xml web service as datasource, if i pass LOGON_USER as parameter it seems the Data View shows unformatted (whithout columns and rows), but if i write the parameter directly in the properties dialog box, the Data view shows well. Is this normal? I have to generate Dataview whithout passing LOGON_USER, and copy the xsl code and paste in another DataView generated with the LOGON_USER parameter Tag: variables Tag: 61187
  - 15
    - How to redirect to a different website after a .wmv file finishes I am trying to get my site to redirect to another site, but only AFTER the video finishes playing. Please provide examples... I'm not too brite with html as it is. Thanks Tag: variables Tag: 61183
  - 16
    - Create a database to store form results I'm creating my web site on my PC first. I will look for hosting once my web site is finished. I try to create a feedback page with ebay style, that means that people would leave positive or neutral or negative rating and leave a comment. Then this input would go into a database and from that, I could calculate the percent of positive feedback and display it. I have 2 questions. 1) Is there something on the web that could guide me on how to do this feedback form and result form ? 2) if not, I can try to do it myself, no problem. But in my form, in form properties, I clicked on "send to database" and "options, On the Database Results tab, I clicked Create Database. Frontpage prompted me to rename my .htm file into a .asp file, which I did. But then, I can't preview this .asp file in Internet Explorer 6. So my question is: do I need a web site hosting company which has Windows server 2003 ? there is no way I can see how my .asp file would look on my local PC ? Tag: variables Tag: 61181
  - 17
    - send to multiple pages it´s possible to send a form to multiple pages? Tag: variables Tag: 61176
  - 18
    - frontpage 2003 does not work with firefox Using FP 2003... when I put links into a text box, no other browser other than IE (esp. firefox) can see the links or use them... ANy suggestions ? I have gotton around the problem for no by not using the text box, but it's really handy, and if there is a work around that would be great ! Thanks ! Tag: variables Tag: 61172
  - 19
    - Hebrew text in English site I have a site www.triplebit.com . My site is in English but I want to add some pages Hebrew ( that are read from right to left). If I add Hebrew text in FP2000 its read bad after upload. Can someone advise please? Regards I. Lesher Tag: variables Tag: 61166
  - 20
    - Database Interface Wizard/FP 2003 FP 2003 I created a database interface which has worked sucessfully in the past and am getting this message when I try to preview in Internet Explorer. Previewing in Firefox works ok. A name was started with an invalid character. Error processing resource 'file:///C:/Inetpub/wwwroot/SAHCAwards2006_interfac... <%@ Page inherits="Microsoft.Office.FrontPage.DBInterface.DBInterfacePage" Src="../../../_fpclass/fpdbnet.cs" Language="C... Also this code is now being added which is usable when published with Firefox but will not post using Internet Explorer. It states Invalid next to the date field. FieldDefaults=",,,,"+System.DateTime.Now.ToString("d")+",,"; <asp:RegularExpressionValidator ControlToValidate="txtDate" ErrorMessage="Invalid!" ValidationExpression="(0?[0-9]|1[0-2])[-/]([0-2]?[0-9]|30|31)([-/][0-9]{1,4})?( )*((0?[1-9]|1[0-2]):[0-5][0-9](:[0-5][0-9])?( )*[aApP][mM]|([0-1]?[0-9]|2[0-3]):[0-5][0-9](:[0-5][0-9])?)?" Display=Dynamic Runat="server"/> Thanks for any help you may be able to give me. Tag: variables Tag: 61165
  - 21
    - Display data entered in form I have a form web part that is successfully sending data to a data view and returning a table based on what the user entered. I'd like to put something at the top of the data view that says "you searched for: <search term here>". I can't find a place to display the data that the user entered in the form. Can someone give a push in the right direction? Tag: variables Tag: 61160
  - 22
    - Receivng Error Message on Submit Form I have a form on my website that submits data to another form using a Submit button. It has been working for over 2 years without a problem. Within the last week the error messaage below is received when submitted. The data is sent to the second form but the email notification does not work. If the email is removed from the submit form there is no error message received. FrontPage Error. User: please report details to this site's webmaster. Webmaster: please see the server's application event log for more details. My server provider gave me the following information: Microsoft FrontPage Server Extensions: http://www.gwrra-mi.org - Error #a0007 Message: Error from search: can't open the word hash file gwrra-mi.org\_vti_txt\default.wti\All.dct unable to open the database He suggested republishing the website to correct the error, that seems extreme. Any help would be appreciated. Thanks, Ted Tag: variables Tag: 61157
  - 23
    - Removing a form/database from a website or editing it? I recently created a website in which I used the database interfacce wizard in Frontpage to create a form a conjoined database in which to store the information. When I set it up, I included a login to protect the database. Well unfortunately I protected the form as well, resulting in the need for a person to login to complete the form. Not exactly what I had in mind. Is there a way to alter it so that the form can be accessed outside the login protection, but have the database remain protected. If not, what is the best way to remove the entire form/database, taking into account that I have already published the site. Thanks, Motts Tag: variables Tag: 61153
  - 24
    - please help Please I need some help. I have this script in my front page working for archiving and it is working perfect but the problem is when i choose for example http://www....com/2006/01/28.htm it works but from this after this date load the page if I go to choose another date it give me like that http://www.....com/2006/01/2006/01/31.htm so I need some help please to let it works. I mean when I choose another date it clear the old one and get the new one choosed. <form onsubmit="getarchive();return false"> <select name=Day size="1" tabindex="1"> <option VALUE=01 selected>01</Option> <option VALUE=02>02</Option> <option VALUE=03>03</Option> <option VALUE=04>04</Option> <option VALUE=05>05</Option> <option VALUE=06>06</Option> <option VALUE=07>07</Option> <option VALUE=08>08</Option> <option VALUE=09>09</Option> <option VALUE=10>10</Option> <option VALUE=11>11</Option> <option VALUE=12>12</Option> <option VALUE=13>13</Option> <option VALUE=14>14</Option> <option VALUE=15>15</Option> <option VALUE=16>16</Option> <option VALUE=17>17</Option> <option VALUE=18>18</Option> <option VALUE=19>19</Option> <option VALUE=20>20</Option> <option VALUE=21>21</Option> <option VALUE=22>22</Option> <option VALUE=23>23</Option> <option VALUE=24>24</Option> <option VALUE=25>25</Option> <option VALUE=26>26</Option> <option VALUE=27>27</Option> <option VALUE=28>28</Option> <option VALUE=29>29</Option> <option VALUE=30>30</Option> <option VALUE=31>31</Option></select><font color="#FFFFFF">/</font><select name=Month size="1" tabindex="1"> <option VALUE=01 selected>01</option> <option VALUE=02>02</option> <option VALUE=03>03</option> <option VALUE=04>04</option> <option VALUE=05>05</option> <option VALUE=06>06</option> <option VALUE=07>07</option> <option VALUE=8>8</option> <option VALUE=9>9</option> <option VALUE=10>10</option> <option VALUE=11>11</option> <option VALUE=12>12</option></select></font><font color="#FFFFFF">/</font><font face='arial ' size=-1><select name=Year size="1" tabindex="1"> <option VALUE=2005>2005</option> <option value="2006" selected>2006</option> </select></font></p> <p dir="ltr" align="left"> <input type="submit" value="Go" style="float: left"></p> <script type="text/javascript"> function getarchive() { var d = document.forms[0] var loc = d.Year.value + "/" + d.Month.value + "/" + d.Day.value + ".htm" document.location.href = loc } </script> </script> </form> Thanks in Advance Tag: variables Tag: 61142
  - 25
    - 'how to put multable lines in navigation bar entry in frontpage' I have not been able to put multable lines in navigation bar entry in frontpage and donot know of the trick yet. -- a question is a question whether you know the answer or not. Tag: variables Tag: 61141

How to put values from variables in this server side ASP script :
mySQL= "UPDATE prereserva SET valor='reservada' WHERE n_prereserva=331"

Top

Re: variables by MD

MD
Wed Feb 08 13:31:55 CST 2006

In VBScript use in ASP

valorVar = request.form("valor")
mySQL = "UPDATE prereserva " _
& "SET valor = '" & valor "' " _
& "WHERE n_prereserva = 331;"

--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com
FrontPage Add-in

"Licass" <l.r.m.d@sapo.pt> wrote in message news:%23y9uLBOLGHA.1180@TK2MSFTNGP09.phx.gbl...
> How to put values from variables in this server side ASP script :
> mySQL= "UPDATE prereserva SET valor='reservada' WHERE n_prereserva=331"
>
>

Top