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 strongm 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: neroe
  • Order by date
  1. neroe

    Row count from join statement

    Thats fantastic, thank you.
  2. neroe

    Row count from join statement

    Hello I have the following SQL; select members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO, events.[DESC], memship.SHIPNO from members inner join bookings on members.REF = bookings.REF inner join events on bookings.EVENTNO = events.EVENTNO inner join memship on members.SHIPNO =...
  3. neroe

    Reserved word DESC workaround for JOIN statement

    Works perfect, thanks.
  4. neroe

    Reserved word DESC workaround for JOIN statement

    Hello I've written the following SQL which works fine; select members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO from members inner join bookings on members.REF = bookings.REF I'd like to add one more field from another table. The name of the field is DESC and I had intended...
  5. neroe

    Writing A Value To A JavaScript

    Morning All I have a JavaScript on a .aspx which is located inside the heads tags. I need to be able to write a variable to the script i.e. var orderRef = <%= varName%>;. But I don't seem to be able to do it as the <%= %> tags do not turn yellow. Any ideas? Thanks in advance.
  6. neroe

    can't email through smtp in local web app

    i have a 2.0 .net web app that sends email. i would like to use it initially on my local system. i have installed the smtp virtual server and in iis set the relay restrictions to allow my current ip address and 127.0.0.1 to relay through the virtual server. i have also done the same for...
  7. neroe

    asp.net login - directory mix up

    thats great, thanks for your time
  8. neroe

    asp.net login - directory mix up

    scenario i have a site that has an admin section to it. the login page to the admin section is accessed using a similar url to this; http://www.mydomain.com/admin section/login.aspx my problem is this piece of code(i think) FormsAuthentication.RedirectFromLoginPag(txtUserName.Text, False)...
  9. neroe

    convert date format on date/stamp

    aha. thanks
  10. neroe

    convert date format on date/stamp

    yes i know. however i am able to do this due to an existing system residing on the server
  11. neroe

    convert date format on date/stamp

    that was taken from the dev server which is displaying in the english format. the live server is displaying the american format
  12. neroe

    convert date format on date/stamp

    this is the design to one of the fields in my db; 1 [timeStamp] datetime 8 1 this is the default value to it; (getdate()) and this is an example of what it stores; 15/06/2005 11:35:41 this format is obviously american . . . i need it to be english. any suggestions welcome. thanks
  13. neroe

    The Simplest Thing...Connection To DB

    the code behind
  14. neroe

    The Simplest Thing...Connection To DB

    i mean, it looks like this; private void Page_Load(object sender, System.EventArgs e) { System.Data.SQLClient.SqlConnection MyConnection; SQLClient.SQLDataAdapter MyDataAdapter; DataTable MyDataTable = new DataTable(); DataRow MyDataRow; string strSQL = "SELECT FIELD1, FIELD2...
  15. neroe

    The Simplest Thing...Connection To DB

    ok, entire page looks like; <%@ Page language="c#" Codebehind="Listing.aspx.cs" AutoEventWireup="false" Inherits="BF_PROffice.Listing" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>Listing</title> <meta name="GENERATOR" Content="Microsoft Visual...
  16. neroe

    The Simplest Thing...Connection To DB

    thats not c# is it?! i'm using c# to do this . . . sorry, i should have said
  17. neroe

    The Simplest Thing...Connection To DB

    any help with this would be greatly appreciated. i have my .aspx with a very empty looking DataGrid on it. i would like to populate it with data from a table i have just constructed in sql server 2000. what is the best way to do this . . . ? does the connection go in the Web.config file. if...
  18. neroe

    link from a pop up into a new window

    no worries . . . fixed it now. setTimeout("self.close()",1250); thank god for google!!
  19. neroe

    link from a pop up into a new window

    this solution has developed a problem. the code worked perfectly in some test pages that I built. once I dropped the code into the pages that I needed it for a problem occured in that the popup dies but it does not open the next fully featured window. however if I put an alert in like this...
  20. neroe

    link from a pop up into a new window

    i knew i'd find a guru . . . thanks very much, worked like a charm first time

Part and Inventory Search

Back
Top