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 Chriss Miller 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: 2ni
  • Order by date
  1. 2ni

    Validate SQL

    I build a store procedure to make a search in my customers table. But i would like to validate the sql query i build berfore running it. Is there a way to do that ? I found something with SET PARSEONLY ON....
  2. 2ni

    Remote debugging

    I had the same problem, my remote server ( Windows 2003) have an integrated firewall software like on windows XP, i stop it and then evrything goes right
  3. 2ni

    Inserting database size into a database

    you can find informations in the sysobects, sysindexes, sysfiles and spt_values tables. If you need informations send by sp_spaceused look in it and take what u need exactly. Here is the source of sp_spaceused : create procedure sp_spaceused --- 1996/08/20 17:01 @objname nvarchar(776) =...
  4. 2ni

    linked server

    the sql user who query your linked server have no rights. So you msut map this user to an user who have rights on your linked server. To do it, go in sql server entreprise manager / security right click on your linked server and choose security. Here u can do ur mapping.
  5. 2ni

    Update Default Value Of A Field In SQL Table.

    You must drop your constraint before adding a new one : ALTER TABLE dbo.<table name> DROP CONSTRAINT <constraint name> go ALTER TABLE dbo..<table name> ADD CONSTRAINT <constraint name> DEFAULT 'GoodBye' FOR <column name> if you ignore the constraint name you can do this : declare...
  6. 2ni

    Spacing columns using an image

    try to enlarge the table width or use the nowrap property in TD tags. To work correctly, you must replace your space by 'non breakable spaces' ( &nbsp; )
  7. 2ni

    How may I speed up this query?

    try to replace this part : from SCHEDULE, PROJECT where PROJECT.PROJECT_ID=@key and SCHEDULE.PROJECT_ID=PROJECT.PROJECT_ID by from SCHEDULE inner join PROJECT on PROJECT.PROJECT_ID=@key and SCHEDULE.PROJECT_ID=PROJECT.PROJECT_ID
  8. 2ni

    sql mail startup problem

    the mail profile must be set under the same <domain><account> that SQL server service start with. on the computer on which SQL server start, launch MMC, look in the server properties with wich account starts SQL and change it with a windows <domain><account>
  9. 2ni

    Stored procedure calling a char based parameter

    if you don't specify the size of ur char the default value will be 1 so what u wrote means @PONUM CHAR(1) then if the field PO_NUMBER is a numeric field u'd better use an numeric parameter
  10. 2ni

    Regex problem

    i want to replace some text using regular expression but it doesn't work : here is my text (some TSQL) CREATE PROCEDURE [dbo].[DELETE_FILE] (@FILE varchar(255)) AS --Comment exec master..xp_deletefile @FILE /* maxi comment */ GO I want to delete blank lines and comments Dim re As Regex...
  11. 2ni

    equiv of ASP chr(13) ?

    this work : <html> <head> <script language=javascript> function fTest() { var szString = new String(); var re = new RegExp(); re = /\n/g szString = (document.getElementById(&quot;TE1&quot;).value).replace(re ,&quot;<li>&quot;); document.getElementById(&quot;TXT&quot;).innerHTML =...
  12. 2ni

    equiv of ASP chr(13) ?

    if i remember \n (linefeed) is the equivalent of a chr(13) & chr(10)
  13. 2ni

    Database idendity

    I have to built a database that i'll copy on three computers. Is there a way to identify each database ? i know how to identify Access with 'Application.ProductCode' which gives me the Access GUID but what i need is a kind of Database GUID
  14. 2ni

    Javascript Form Validation

    you should have a look to regular expression function numbersOnly(szString) { var RegEx = new RegExp(); RegEx = /^\d+$/ return (RegEx.test(szString)); } for the age between 1 & 100 if (numbersOnly(age) && parseInt(age) > 1 && parseInt(age) < 100)
  15. 2ni

    Any easy way around a subquery that returns more than one value?

    i had the same problem, the subquery return more than one result because two or more value in your [to date] column are equal try to use this in your subquery : select max(distinct [to date]) ....
  16. 2ni

    Run script from dropdown without using a button

    i don't understand well what you want to do, but you shouldn't use this : <select name=&quot;select1&quot; onChange=&quot;document.myform.submit()&quot;> it post the page on itself and you'll loose all your data don't use the onchange event on your 'option' tag and try something like this...
  17. 2ni

    Searching String

    function inStr(szStr,szChar) { return (szStr.indexOf(szChar) != -1) ? true : false; } alert(inStr(&quot;123456&quot;,&quot;3&quot;)); alert(inStr(&quot;123456&quot;,&quot;8&quot;));
  18. 2ni

    Server.htmlDecode help. Urgent

    Private Function HTMLDecode(byVal encodedstring) Dim tmp, i tmp = encodedstring tmp = Replace( tmp, &quot;&quot;&quot;, chr(34) ) tmp = Replace( tmp, &quot;&lt;&quot; , chr(60) ) tmp = Replace( tmp, &quot;&gt;&quot; , chr(62) ) tmp = Replace( tmp, &quot;&amp;&quot; , chr(38) ) tmp =...
  19. 2ni

    How to count Mondays between two dates

    I want to know how many monday i have between 2 dates. Anyone can help me please ?
  20. 2ni

    include some asp within javascript

    here is a way of doing : <html> <head> <script language=javascript> function fAlert(FLAG) { if (FLAG == 1) alert(&quot;Message 1&quot;); else alert(&quot;Message 2&quot;); } </script> </head> <body OnLoad=&quot;fAlert(<%=YouASPVariable%>)&quot;> </body> </html> another way : <script...

Part and Inventory Search

Back
Top