Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JohnBeals
  • Content: Threads
  • Order by date
  1. JohnBeals

    Setting up an email server

    Is it possible to set up an email server on a Home NT4 Server with IIS? Here's my sit. Registered Domain Name Server (let's say it's myserver.com) Full-time connection to server via Cable Modem. Router IIS Installed - web server working on a NT4 Server. Email addresses for the family using the...
  2. JohnBeals

    Users don't see the background on website

    I have a website running IIS. The pages use Cascading Style Sheets. Some users don't see the background on the web pages unless they refresh their screen by resizing the browser or opening another window over the browser. You can literally "paint" the background with a smaller...
  3. JohnBeals

    Query 2 identical tables question

    I have two tables that are identical. One holds current data and one holds historical data. When we're finished with a record we move it to the historical table. This is a new process to speed up the application. I need to query both tables for reports. I'm drawing a blank on this. I...
  4. JohnBeals

    How to display a message until records are retrieved?

    I have a stored procedure that takes 10 - 15 seconds to run. I need to display a "Please wait" message until the records are returned. Then the "Please wait" message is replaced by the records returned. Any suggestions? Thanks, JB
  5. JohnBeals

    Problems retrieving Record Identity after INSERT

    I need to capture the Identity field after inserting a record. I was told to use the @@IDENTITY (http://msdn.microsoft.com/library/en-us/tsqlref/ts_globals_50u1.asp) function. So I have this: <cfquery name=&quot;InsertRequest&quot; datasource=&quot;#db#&quot;> INSERT INTO tbl_SchedJobs...
  6. JohnBeals

    How to retrieve Column Identity after Insert?

    On SQL 7, using a Query Insert: I need to get the Column Identifier of the new record after an Insert. Does the Insert return any values? My concern is, that if I get the last ID and then assume the next ID is from the record I inserted, another user could possibly do an insert between my...
  7. JohnBeals

    How to move entire MSSQL7 Directory to another drive?

    I need to move the entire installation of MS SQL 7 to another drive. It was installed on C:\MSSQL7, and now of course we're out of space on C: drive. Can I back up the databases, uninstall SQL 7, install SQL 7 on the other drive and then restore the databases? Thanks, JB
  8. JohnBeals

    Is there a standard phone number validation script around?

    I am looking for a standard phone number validation script. Mine is below, but it's a bare minimum. I'd like something a little more robust without having to reinvent the wheel. If you have one you'd be willing to share, I'd appreciate it. JB function isPhoneNumber(inputVal) { inputStr =...
  9. JohnBeals

    Message box with onMouseOver and onMouseOut

    I want to create a message box that appears when mousing over a form entry description, and disappears when mousing out. It will contain help info on the entry. I've seen this on lots of sites. I don't think Alert will do because I don't want the user to have to click an &quot;OK&quot; button...
  10. JohnBeals

    Submitting a form to itself doesn't pass values?

    I have a form that displays differently based on the input. I change a variable and want to redisplay data with a button click. See code below. (function info) function ExpJobGrp(stuff) { var NewInd_Id = 10 document.frmInd_Per.Ind_ID.value = NewInd_Id document.frmInd_Per.submit() location...
  11. JohnBeals

    Setting a form value

    I am trying to set a form value based on input. What happens is javascript returns a blank to the form. My code is below. The problem occurs at line 22 - entry1.value = column. Column has a value (as the alert shows) and entry1.value has a value but after setting entry1.value = column then...
  12. JohnBeals

    Displaying a page as an Excel Spreadsheet in IE

    I need to display an Excel Spreadsheet in IE. CF creates a report, which I am currently displaying in a table. There is a similar report in .asp that displays the excel spreadsheet in IE, using Response.ContentType = &quot;application/vnd.ms-excel&quot; (at least I think that's what's causing...
  13. JohnBeals

    Need help with Javascript Error &quot;Object expected&quot;

    I am getting a Javascript Error: Object expected. The error occurs at the line If (IsText >= 0) I can't figure out what's wrong! Any help is appreciated! Thanks, John Here's the file; You can copy and paste it to test. <!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot;>...
  14. JohnBeals

    How to do a Query Dump?

    I occasionally query a data source and just want to see the query results. Is there a way to do a query dump without having to create a structures html page and doing a cfoutput? I want to dump this in a .cfm page, not use SQL Query Analyzer or Enterprise Manager. TIA John
  15. JohnBeals

    Error in my function. Can someone take a look?

    I have been trying to get this function working, to no avail. I still get an error on page load. The return results value is just for testing right now. The error I get is Error: Expected ';' and occurs right after If (IsText > 0) If I remark out the If and Return statements and unremark the...
  16. JohnBeals

    Passing a Form Select Name to a function

    I am trying to pass a form select name to a function as a variable, and then use that name to get data from the form. IE: ... <script language=&quot;JavaScript> function CheckValue(x, y){ var Test = document.form[0].x.value (check Test for whatever...) document.forms[0].y.value = Test }...
  17. JohnBeals

    Background Image does not display in IE 5.5

    I added a background image to my site, and it is not appearing unless I resize the window. The site is set up to work with IE 5.0 and later, and this happens with IE 5.5. I reference the .CSS file here... <HEAD> <LINK REL=&quot;stylesheet&quot; TYPE=&quot;text/css&quot...
  18. JohnBeals

    Passing Text Variables in VBScript

    I am having a problem passing a text variable. I'm doing something wrong, but don't know what. Here's the code... 1 Dim FormNum 2 Dim FormValue 3 Sub JobIDSubmit_onclick 4 Dim JobID 5 call ValidateForm(0, JobID) 6 JobID = document.forms(0).JobID.value 7...
  19. JohnBeals

    Losing CR / LF in TextArea w/vbscript

    When submitting a form using vbscript, I loose the CR/LFs. If I use a submit button instead of vbscript, the CR/LFs are passed. Using vbscript: Sub btnOK_onclick Dim Comments Comments = document.forms(0).txtComments.value window.navigate(nextpage.cfm?Comments=&quot; & Comments) In the code...

Part and Inventory Search

Back
Top