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 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: neroe
  • Content: Threads
  • Order by date
  1. 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 =...
  2. 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...
  3. 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.
  4. 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...
  5. 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)...
  6. 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
  7. 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...
  8. neroe

    link from a pop up into a new window

    the scenario; i have a regular .html, on it is a link to a popup. once the link is clicked the user is to answer the questions presented in the popup.the popup has no statusbar, toolbar or scrollbar as i have set these to "no" in the function that fires the popup from the first page. once the...
  9. neroe

    prevention of multiple db entries using onClick in a form

    i have a form, which when submitted writes to a database. a few times users have been clicking the submit button twice hence the data has been written back to the database twice. i have fixed this problem by using the onlick event off the (graphical) submit button by putting a small script that...
  10. neroe

    Maintaining List Box State

    The scenario; I have a questionaire (containing 13 questions). The methods of answering the questions are a mix of dropdown lists (and then a 'Next'link) and links. Only one question at a time appears on the ASP, so it basically submits to its self each time producing the next question. The...
  11. neroe

    image in a drop down box

    is it possible to place a small image in a drop down box using asp.net. the kind of effect i'd like to acheive is similar to the address bar in internet explorer where the icon is relevant to the url and is displayed to the left hand side of the url text.
  12. neroe

    Image In A Drop Down Box

    is it possible to place a small image in a drop down box using css. the kind of effect i'd like to acheive is similar to the address bar in internet explorer where the icon is relevant to the url and is displayed to the left hand side of the url text.
  13. neroe

    inserting data through a textbox to an access database

    i have a form with a textbox on it and a button. the form has a test connection success to an access database consequently i have been through the motions of adding an oledbdataadapter etc. could anyone provide me with the correct code so that onclick of the button the data is (simply)written...
  14. neroe

    101 Visual Basic and C# Code Samples

    hope this solves a few problems for some of you out there http://www.microsoft.com/downloads/details.aspx?FamilyId=08E3D5F8-033D-420B-A3B1-3074505C03F3&displaylang=en
  15. neroe

    maximum number of nests allowed in a trigger anyone?

    any of you guys know what is the maximum number of nests allowed in a trigger? thanks in advance
  16. neroe

    oracle to microsoft sql syntax conversion

    thanks in advance for any help on this. im a newbie to sql so this question probably is so simple for you guys. can anyone change the syntax of this line in order for sql server 2000 to take any notice of it constraint emp_pk primary key (emp_id);
  17. neroe

    Access connects fine, but I got problems with SQL

    Any help with this is greatly appreciated, thankyou. I currently use the below VBScript to connect to a Access database and it all works perfectly. <% 'Request the name of cars and the primary key from the Cars table. SQLCAR=&quot;SELECT carName, carID FROM Cars&quot; set conncar =...
  18. neroe

    How Do I Set The Browser Size After Using &quot;_blank&quot;

    Hi What I want to do is use _blank in <a href></a> so that when the new browser window opens it opens at a size that I have set. I'm sure this goes in <a href></a> but I'm not sure how. Thanks in advance neroe
  19. neroe

    dataConnect.asp - Is This Written Correctly?

    Howdi, First up any help with this would be greatly appreciated, thankyou. I have written a small web site that uses VBScript and HTML to produce ASP which all operates through IIS on my XP Pro PC. The website also connects to an Access backend. It all works fine so I decided to take it a few...
  20. neroe

    dataConnect.asp - Is this written correctly?

    Howdi, First up any help with this would be greatly appreciated, thankyou. I have written a small web site that uses VBScript and HTML to produce ASP which all operates through IIS on my XP Pro PC. The website also connects to an Access backend. It all works fine so I decided to take it a few...

Part and Inventory Search

Back
Top