Jump to content

aspnetguy

Members
  • Posts

    6,787
  • Joined

  • Last visited

Everything posted by aspnetguy

  1. what do you mean connect forms in VB6? Why do you need ot connect forms.Why can't you do everything on one form? You can process the same form multiple ways based on the events that are fired.Reconsider your design, you are probably making it more complicated than it needs to be.
  2. i reccommend the 2nd method shown above.Any changes you need to make you only have to make once, but can apply it to many tags.
  3. I don't see how you can even use javascript at all, it can't talk to a databse or anything.You need a database and a server side language like ASP.Net or php.I agree that counters can be easily manipulated, if they are written wrong! They should only log unique visitors (ipaddress) and not muliple hits to the same page, by the same user, every couple minutes.
  4. Using a style sheet and defining the font-size will override this function of FIreFOx.font-size: 12pt or font-size: 16px (sizes may not be equal)defining it in pixels seems to be the most accepted way although I am not sure why. I usually use points (pt) and have never had any trouble with it.Cheers
  5. aspnetguy

    html 4

    The only difference is excepted syntax...don't waste your time on either of them. learn XHTML 1.0 Transitional and you will be set for many years. I fyou don't you will be forced to learn it in the future when it finally replaces HTML 4.
  6. What you described here is Cold Fusion (.cfm) NOT sql. You made no reference to MS SQL Server in the code you provided. You are NOT using SQL to send mail, you are using the built in mail component of Cold Fusion.
  7. Try this articlehttp://www.joeclark.org/access/captioning/...bed-object.html
  8. Here are some differences between databaes and the TOP statement.SQL Server:SELECT TOP 10 product, descr, email FROM products ORACLE:SELECT product, descr, emailFROM products WHERE ROWNUM <= 10MySQL:SELECT product, descr, emailFROM productsLIMIT 10New Queries for oracleSELECT s.STNO Student#, NAME Name, SUM(AMT) AmountFROM student s, finance fWHERE s.STNO = f.STNOGROUP BY s.STNO, NAME HAVING SUM(AMT) = (SELECT SUM(AMT) FROM finance WHERE ROWNUM <=1 GROUP BY STNO ORDER BY SUM(AMT) DESC)OR SUM(AMT) =(SELECT SUM(AMT) FROM finance WHERE ROWNUM <=1 GROUP BY STNO ORDER BY SUM(AMT) ASC) SELECT COURSE Course, SUM(AMT) AmountFROM student sINNER JOIN finance fON s.STNO = f.STNOWHERE ROWNUM <=1GROUP BY CourseORDER BY SUM(AMT) DESC Hope this solves the issue.
  9. SQL is for talking to databases. How do you send email with SQL. Your form indicates you are using Cold Fusion, what SQL are you using?
  10. Or you could just check the Database values before you execute the statemnt in your server code...not as fancy as a Stored Procedure but maybe easier if you are not familiar with them.
  11. BTW these queries where written for SQL Server 2000 (what I have on hand at the moment), if this is for another Database you may have to tweak them a bit.Is this for a class or are you learning on your own?either way you probably have learned nothing from this, I really am not helping you but I know the feeling. I passed in many incomplete SQL Assignments in college. But I kept trying and here I am 3 years later and I am very confident in SQL.Good luck.
  12. and finallyquery 2SELECT s.STNO Student#, NAME Name, SUM(AMT) AmountFROM student s, finance fWHERE s.STNO = f.STNOGROUP BY s.STNO, NAME HAVING SUM(AMT) = (SELECT TOP 1 SUM(AMT) FROM finance GROUP BY STNO ORDER BY SUM(AMT) DESC)OR SUM(AMT) = (SELECT TOP 1 SUM(AMT) FROM finance GROUP BY STNO ORDER BY SUM(AMT) ASC)
  13. Query 3SELECT TOP 1 COURSE Course, SUM(AMT) AmountFROM student sINNER JOIN finance fON s.STNO = f.STNOGROUP BY CourseORDER BY SUM(AMT) DESC
  14. lol, don't want to do your homework?Okay I'll bite.Here is Query 1SELECT s.STNO Student#, NAME Name, AMT AmountFROM student sINNER JOIN finance fON s.STNO = f.STNOWHERE METHOD <> 'CASH'
  15. Actually you can send mail with action="mailto:.....It is the email client on the users machine, in this case Outlook Express, that screws things up. I have been able to successfully send forms like this (it was on a Intranet with web based email through Exchange so there were no email clients to mess up the process.So, your syntax and application of the example is indeed correct, just not a very reliable method due to issues with email clients.Note: not all email clients mess up the process, but Outlook does and since that is by default on most windows computers, whether used or not, it will be a huge obsticle.The javascript will work but I would suggest a server language to send the form.Hey Prof Dan, you must be a PHP guy! lol. Everytime I have seen you suggest a language it is PHP...I am the opposite...ASP.Net all the way. Not that there is anything wrong with PHP, I am just glad I got out of scripting langauges, I prefer compiled code, better for software dist.
  16. Don't give in and use an HTML editor like Dreamweaver easier. If you do that you won't ever learn HTML, even looking at the code generated by the editor won;t help much because it won't be concise or clean. Editors are design to 'make it work' not write nice code.
  17. name or id? Doesn't matter.both are accessible from javascript for validation, just done 2 different ways, instead of document.form.name.value it is document.getElementById("id").value.Besides I can't see XML replacing XHTML for layout of a webpage. It is better suited for things like RSS Feeds and Web Control component attributes.
  18. The connection string is the easy part but if you don't have your security setup correctly it won't work anyway!
  19. I have 1024x768 resolution and I do not have to scroll.Any user without a scroll mouse (and resolution 800x600 or less) can scroll the page before they mouseover the menu...I am sure what you are asking can be done with javascript...I just don't know how either.
  20. aspnetguy

    linking

    you could use javascript to open a new window containing the pdf when the page loads instead of waiting for the user to click the link.
  21. You are using Classic ASP scripting style...it may take some time but look into do things the ".Net" way.I think you will find that Data binding will solve your problem
  22. try this posthttp://forums.asp.net/1106005/ShowPost.aspx
  23. I am not sure of any products, a Google search for Web file manager turned up nothing????Is your site using codebehind or inline coding??? If it is using codebehind you may have trouble finding a product for that. But inline coding could be accomplished with just about any product.Duh, you said you used Visual Studio so it must be codebehind...I think you will have a hard time finding a product that will compile your codebehind before publishing.modifying the .aspx.cs files is not enough...infact the site will run without them.They depend on the compiled .dll's.
  24. aspnetguy

    what is the problem??

    You can't just use Response.Write. That is for writing text but DropDownList1 is an object.You have to add it to the Page COntrols.Dim DropDownList1 As New DropDownListDim objCmd As New OleDbCommand("SELECT id FROM student", objConn)Dim objD As OleDbDataAdapterobjD = New OleDbDataAdapter(objCmd)Dim data As New DataSetobjD.Fill(data, "student")DropDownList1.DataSource = dataDropDownList1.DataBind()Controls.Add(DropDownList1) 'Use this line to add it to the page
×
×
  • Create New...