Search results for query: *

Hi! I made a online test application where I need to work with session variables. I got this code session_start(); if (!session_is_registered("test_session")) { session_register("totaltest_session"); session_register("test_session"); session_register("pregunta_session")...

Hi! I got mys site which is running ok at my localhost. I upload it and when I want to access it will return: SELECT * FROM horoscopo where dia=09 and mes=12 and ano=2005 order by id asc limit 0,30 query failed. The database, username and password are ok cause if I change anyone os those I...

Hi! I'm migrating my site form mssql & asp to mysql & php and I'm having a problem with this sql sintax. What I do is select a value between 2 dates and show the results but I cannot figure how to do it in mysql. My mssql sintax is: $sqlstm="SELECT * FROM vidas_pasadas where...

Hi! I am migrating from MSSQL to MySQL and I'm having trouble converting the SQL strings. I got thins: '' strSQL = "SELECT top 1" & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Thread.Topic_ID, " & strDbTable & "Thread.Thread_ID, " & strDbTable &...

Hi! I uninstalled an application and at the end I manually removed the app directory, que thing is that everytime I reboot my PC an instance of Winsows Installer will startup trying to finish uninstalling the app. How can I do to prevent windows installer to open? I tryed msconfig and it doesnt...

Hi! I changed my PC and now if I have my PC on and I turn the monitor power on it will reset my PC!~ It doesnt happen with the old PC, does anyone knows why its doing that? Tnx!

Hi! I'm do not program SQL and I need to create a stored procedure from this sql syntax: varDate = date() varDay = DatePart("d",varDate) varMonth = DatePart("m", varDate) varYear = DatePart("yyyy", varDate) "SELECT * FROM adefemerides where mes="&varmonth&" and dia=" &varday &" and...

Hi! This is my first time woking with datagrids. I made an application that will return all the access table contents in a datagrid and if you press the exit button it will write new content entered by the datagrid in the table. In access when you open a table you can select some rows and copy...

Hi! I could create and drop stored procedures but to show the sp code I have to use: sp_helptext urprocedurename But, how can I use this command to retreive the stored procedure code and response.write it on my website page? Tnx!!!

Hi! I'm not into SQL programming and with help of you guys I created my first stored procedure. Now I can call it any time from my website but since I dont have the sql enterprise manager at home I was trying to make an application like enterpriese manager but in asp. I created stored procedures...

Hi I got this stored procedure (my first time using it... create procedure usp_ReturnData as select * from efemerides where mes = month(getdate()) and dia = day(getdate()) and anofecha = year(getdate()) go I normally call the recordset like this: sqlstm="SELECT * FROM efemerides where...

Hi! I got a website that has some asp pages that receives more o less 12.000 hits per day. In that page I show only one recordset which date is equal to the current date. Here is my sql: varDate = date() varDay = DatePart("d",varDate) varMonth = DatePart("m", varDate) varYear =...

Hi! I am working on an application that has to work on windows CE and part of this application must send an email but I found that I cannot authenticate. I found a class that can authenticate thru smtp but i wont authenticate thru pop. Does anyone knows how to authenticate thru pop? I dont know...

Hi! I got this table: <table width="10%" border="0"> <tr> <td><font color="#CCCCCC">TEXT</font></td> </tr> </table> and I would like to change the table background color and text color on mouse over. I want to set the table background color to #ffffff and the text to #000000. I tryed...

Hi! Can I get the keywords that a user entered in google when the use enters my site? I saw some sites where they can capture that criteria and I would like to add that feature to my site. How can I do it in asp? Tnx!!!

Hi! I made an aplication to create and manage sql server tables. I use sintax like CREATE TABLE for example. Is there any sintax like that to create a stored procedure? Tnx!!

Hi! I made a send mail page for the user to contact me, the problem I have is that some characters cannot be seen in outlook. Characters like this: á é í ñ, etc I see them in the html but are not displayed, for example, I see: á instead of á can that be fixed? This is my code: <% msg=msg &...

Hi! In access you can set a field to be autonumeric to use it like an ID & primary Key... If I set a field like INT & Autonumeric & Primarykey how big can be the number? does it have a limit? Tnx!

Hi! Thanks to SqeakingSweep I could manage to force to change everynull date value to date.now. I'm not used to work with dataset and datareaders and datagrids but this time I got to use them and I need a hand. This datagrid thing is a small (very small) part of the project and I cant skip it :(...

Hi! I made an app that creates .ale files (example: mysite.ale) and I what I want to do is that when an user double click on any .ale file is to open it with my application. If I associate the .ale extender with my app it will open without any problems. What I want to know if is there anyway to...