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!

  • Congratulations Chriss Miller 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: scripter73
  • Content: Threads
  • Order by date
  1. scripter73

    Mac v. Windows-Based PCs

    Hi, I have a general question. As a web developer I have primarily worked on PCs my entire life. While in school and on a few job assignments, I've had the opportunity to work on Macs - albeit too briefly. The last time I worked with a Mac was in 2000 and have always had a favorable...
  2. scripter73

    How Can I update my Query?

    Hi, I have a query result, CustData. I would like to update 2 fields in the query result, Acct Access, and Current . Since I know the names of these fields, I know that sometimes they are populated and sometimes not. I want to loop through my query result, and say, "If I'm on this particular...
  3. scripter73

    Two SQL statements - Not Sure How to Proceed

    I originally posted this in the ColdFusion forum, but since its more of a SQL-related question - thought I'd post here. ------------ I have a query result set that was created with several joins. Here’s the abbreviated version: <cfquery name="CustData" datasource="#request.dsn#"> SELECT...
  4. scripter73

    Should I Update My Query?

    I have a query result set that was created with several joins. Here’s the abbreviated version: <cfquery name="CustData" datasource="#request.dsn#"> SELECT ….field list values here FROM Customer pc left join area a on pc.area = a.areaid LEFT JOIN layout l ON pc.DefaultInvoiceLayID =...
  5. scripter73

    Installation Question

    I have the Macromedia DevNet CD that supposedly has Dreamweaver, Fireworks, Flash, FreeHand, Contribute, and Homesite 5.5 on it. However, when I get ready to install, I don't see an option for Homesite specifically. I've installed it using this CD before, but can't remember steps taken. Is...
  6. scripter73

    Opening Query Results in Excel

    Hi, I have a query that returns my resultset in the Excel application. The only problem is every data element is put on another row instead of in another column of the same row for every currentrow. <cfquery name="get_custs" datasource="customers" maxrows=20> select custid, contactid...
  7. scripter73

    Looping Through Query Results

    Hi, I used to know how to do this before I left CF for about a year. Hope this is a simple question. I have a query. <cfquery name="get_cust" datasource="customers" maxrows=20> select custid, contactid, custname_contact, firstname, lastname, type, workphone, address...
  8. scripter73

    Basic &lt;CFQUERY&gt; Question

    Hi, I know I should probably pick up a book instead, but I thought I'd ask the community. Has anyone every seen a query statement as the following: <cfquery name="getDaily" datasource="#request.dsn#"> -- #SCRIPT_NAME# #session.username# Select statement..... </cfquery> In my years of...
  9. scripter73

    Has anyone taken the CF TeckCheck Exam?

    Hi, Just a quick question. Has anyone taken the ColdFusion TeckCheck exam? If so, could you provide some insight on the types of questions they focus on? Syntax? More logical? I'm currently brushing up with my nose in a book, but just thought I'd take a chance that someone had taken it...
  10. scripter73

    Dreamweaver Asks for a Datasource Login ID/PWD

    Hi, I just installed an evaluation version of CFMX and Dreamweaver on my machine. I'm setting up a website to begin going through the tutorial and I have just setup my RDS. My website name is "ows" and I've already created a datasource in the Administrator as "ows". Now when I'm in...
  11. scripter73

    Session Variables Not Creating

    Hi, I have been programming with CF for a while, and haven't seen anything like the following. I have a registered domain name that was parked with registrar A. Meanwhile, I was searching for a web host that hosted CF and found them. I pointed my information on registrar's A's site to point...
  12. scripter73

    LoginStatus

    Hi, I want to set a session variable that indicates whether a login was successful. I have the following in my login page: if (Login's Successful){ s.setAttribute("loginStatus",false); response.sendRedirect("loginInvalid.jsp"); } else{ s.setAttribute("loginStatus",true)...
  13. scripter73

    Testing Empty String in JSP

    I have the following in a .jsp that's called from a form: String myString = request.getParameter("formfield"); If the user doesn't enter anything in "formfield", it should be blank. So how come when I say: if (myString == "") //representing null out.println("field is blank"); It...
  14. scripter73

    Disable Fields Then Enable Them Again on Select

    Hi, I have a form containing a select and three text fields that's defined as follows: <form name="searchActForm"> ..... <select name="actdate" size="1" onchange="DisableDate();DisableName();"> <option selected value="" onchange="EnableDate();EnableName();">Please select</option>...
  15. scripter73

    Passing a Form Field to a Page on Other Server

    Here’s what I have: Index.jsp …..contains function openWin() { wpiWindow = window.open ('http://servername/CustProj/displayform.cfm', 'newWindow','width=700,height=500,'+ 'status=no,toolbar=yes,menubar=no,location=yes'); } …..uses an include file (customer.html) that looks...
  16. scripter73

    Can't Pass Form Elements to a Page in New Window

    I’m not sure if this belongs on the JSP forum, the CFM forum, or HTML, but I’ll start here. I have a JSP page that has an embedded HTML form: Index.jsp: <html> <body> …..embedded HTML form <form name="CustEntry" method="post"...
  17. scripter73

    SimpleDateFormat

    Hi, Does anyone know the simplest way to take a current date like now, and convert into a MM.DD.YY format? I went out on the net and I've seen several Java docs for SimpleDateFormat, but not one good example. I'd like to do it in a simple <%= ..... %> if possible. Also, would I need to...
  18. scripter73

    Can't Save Session if Field is a Double

    Hi, Relatively new to Java. Can someone explain why I can't do the following? I have a function that grabs a database element called getCustId(). The function returns a double. Here's what I want to say: * Custdata is my database object. HttpSession s = request.getSession()...
  19. scripter73

    Syntax Error?

    Hi, Can't seem to find out why my compiler keeps saying I need to add a ';' in my .JSP Here's the error message: Generated servlet error: [javac] Compiling 1 source file C:\Tomcat 5.0\work\Catalina\localhost\pos-webapp\org\apache\jsp\loginProcess_jsp.java:110: ';' expected ^ 1 error...
  20. scripter73

    Updating Tomcat 4.1 to version 5

    Hi, I have Tomcat 4.1 installed. I need to update to version 5. Do I need to "uninstall" or can I install over the current version. I'm concerned about losing my C:\Tomcat4.1\....\webapps. I've already saved the directory onto my hard drive though. Thanks, scripter73 Change Your...

Part and Inventory Search

Back
Top