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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by neroe

  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...
See more

Part and Inventory Search

Back
Top