Jump to content

aspnetguy

Members
  • Posts

    6,787
  • Joined

  • Last visited

Everything posted by aspnetguy

  1. Are you trying to use this in a class or just in a regualr form?If it is in a class you will need to use HttpContext.Current.Response.Write or you can make a HttpContex variable to be reused with in the class HttpContext c = HttpContext.Current;c.Response.Write();
  2. Why not just do this SELECT users_nickFROM usersWHERE users_nick != 'admin'
  3. aspnetguy

    Images?

    merged topics, please avoid posting the same questions more than once
  4. aspnetguy

    Images?

    You can store images directly in the database (takes a lot of database space) or you can stored the path (a string) to the image in the database and have the images in a folder on the server.MySql is a databae server software. You will have to download it from mysql.com and install it. You then can staqrt running queries on it after you have turned it on.I would recommend getting phpMyDamin for MySql administration or else you will have to use mysql from the command line.
  5. sweet job scott.You rock at JS.I am starting ot get more comfortable with JS and can do most things I need but this is amazing.
  6. So I am guessing since you didn't actually ask a question that this code doesn't do want you want described above???Could you post the page source from the browser, I do not have an ASP server to test this code but would be happy to take a look if you can provide the rendered HTML.
  7. When setting up my asp.net applications with sql server 2000 I had to create a user in sql server 2000 called 'network service' this is the account the .net code runs as (the account is 'aspnet' if using windows xp).Make sure you create a sql server account named 'network service' and give it permission.Also is the Sql server on the same machine as your .net application or are you trying to remotely connect to sql server?
  8. aspnetguy

    HELP!

    You cannot link 2 databases. You can store both sets of data in different tables within 1 database.If you make 2 databases you are going to run into to problems trying to maintain it and it will be a nightmare making simple join queries.
  9. Works fine for me. Did you fix it?
  10. yes but what server side language are you using to talk to the database. Ajax just send the requests to the server side code and receives response from the server code.What language and what databse are you using?
  11. aspnetguy

    HELP!

    Do you mean link 2 tables together? Everything for a project should be stored in 1 database.When linking 2 tables they have to each have a column that is the sameieitems---------------item_ID int PKName varchar Desc Varcharcustomers---------------cust_ID int pkitem_ID int FKAddress varcharYou can link the 2 tables like this SELECT * FROM items i, customers cWHERE i.item_ID = c.item_ID This will select everything from both tables.
  12. try this SELECT av.Omim_NoFROM av,cs,ti,ti_alt_title,txWHERE av.Omim_No = cs.Omim_NoAND av.Omim_No = ti.Omim_NoAND av.Omim_No = ti_alt_title.Omim_NoAND av.Omim_No = tx.Omim_No
  13. That is it...it is a full query.
  14. Sql server does not have the autoincrement property, it has IDENTITY which does the same thing.http://msdn.microsoft.com/library/default...._ia-iz_3iex.asp
  15. aspnetguy

    mysql problem

    if you are using phpMyAdmin to administer the mysql databses I would recommend exporting them to sql or text (for both laptop and server versions) then compare the output sql and make sure they are 100% the same.It may be a simple inconsistancy.
  16. You can set your database field to type date or datetime. Then you can insert a date (02/11/2007) into the database. You don't need the $date function for that, just to get today's date when selecting future days to see if the date in the datebase is greater than today's date.If you need me to further explain this just ask and I can write a short example.
  17. You should include the year. In fact you should just create a date field in your database and store the actual full date.then you can do this $sql = "SELECT * FROM events WHERE thedate >= " . getdate() . " ORDER BY thedate LIMIT 4";
  18. aspnetguy

    still problem

    please respond in the same thread you made. Do not make new threads for replies.
  19. Are you sure you downloaded the Windows Installer version??? It should be a breeze with that.
  20. You will have to set the Button to Button.Attributes.Add("onclick","return false;");And with javascript capture the enter keypress event
  21. You may have Access denied problems if it is on a different domain
  22. aspnetguy

    Jobs in XML

    You will not find a career only using XML. XML on it's own doesn't do much.There are geneally 4 paths you can take as a web designer/programmer.You can go with windows technologies (ASP/ASp.net, SQL Server)You can go open source (Php, MySql)You can go Sun (JSP,MySQl, oracle)Or you can go desktop only (C++, .Net, JAVA)I would recommend either ASP.Net/SQL Server or PHP/MySql and learn XHTML, CSS, JavaSCript and XML and you should be set for life
  23. Are you setting any cookies when the user logs in?I use $_SESSION to log user info on login...these automatically expire when the browser is closed.
×
×
  • Create New...