- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 2
- Downvotes Received
- 3
- Posts with Downvotes
- 3
- Downvoting Members
- 3
20 Posted Topics
It may be better solutions out there, but i have solved it this way: 1. I have created a folder on the webserver that empties every night 2. When a visitor clicks on playing the MP3 file I use FSO to look if it exists in the temp folder with …
I'm using jQuery contains to show records in a page that contains information that matches a search field. This functions works very well, a bit too good actually... The challenge is that it also searches for matching words in SELECT elements that is inside the table column. $(this).find('td:nth-child(2)').each(function () { …
Hi, Simply use this example: [CODE]SELECT * FROM <TABLENAME> WHERE convert(varchar(10),<DATETIMECOLUMNNAME>,101) = convert(varchar(10),GETDATE(),101)[/CODE]
[CODE] <script> var counter1 = Math.abs(5/160); var output = counter1; alert(output); var counter = String(output).split('.',1); alert(counter); </script> [/CODE]
I have a Visual Basic 6.0 application, it contains a form with onload event, and a Timer. When I run the application as a scheduled task (Run as: Administrator, Run: At system startup) it executes the onload event, but it will not start the Timer. If I run the application …
SELECT TOP 1000 * FROM <TABLENAME> ORDER BY ID DESC But i belive this should have been posted under Database, not JavaScript...
Many people would probably think this question is stupid, but how can i insert a value that starts with 0 in a Bigint/Numeric/Int field? This would normally not be a problem, just using a varchar field instead, but because of the index speed (this is a very large table with …
I have multiple external databases that i want to connect to, from a stored procedure. What server the database is located on is dynamic (a record in a table). All of the external databases are LinkedServers, but also here i need to be able to define what server dynamicly. It …
Butifull collection with over 50 Windows 7 wallpapers: [url]http://www.wallpaperweb.org/wallpaper/Computer/Windows-7-Ultimate.html[/url]
Classic ASP and text/ntext is pain, but if your running SQL 2005 then you can use varchar(max) insted, i have not experienced any problems i had with ntext after i switched over to varchar(max). If your handling datatype TEXT then you should drop using it with the trigger, and change …
Remember that frameset should not use <body> and </body> tag. Example: [code=html]<html> <frameset cols="25%,*,25%"> <frame src="frame_a.htm" /> <frame src="frame_b.htm" /> <frame src="frame_c.htm" /> </frameset> </html>[/code]
I have a INSERT, UPDATE trigger on a table, it works great and helps me from firing a stored procedure from all the (think it's over 50places) where it is needed. But I have one batch update to this table, that doesn’t require the trigger procedure; the trigger is very …
The issue isn't how to use sp_send_dbmail, because i use it everywhere, for both querys and system mails. But i have one problem, and that is how do you send a mail with HTML and TEXT format? You probably wonder why i need this because all the mail readers now …
Error message ”[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.” comes when you insert/update a larger value than the column is specified for. But is there a way to detect what column, or what value that is to large? I’m thinking about splitting up the INSERT string, …
Your code in the TRY don't fire a error into the catch. If you run this one you will se that it prints out ERROR: [code] BEGIN TRY DECLARE @INT AS INT SET @INT=CAST(GetDate() AS VARCHAR(2)) END TRY BEGIN CATCH PRINT 'ERROR' END CATCH [/code] But this dosn't print 'ERROR': …
Sorry but i don't think it's possible in SQL 2008 either, I don’t even think it have been discussed. Most database designers use table names to categorise, and if they don’t then they change to categorised table names later. By using the same table name structure as sknake mentioned.
Try to change: [icode]if(update(ReturnedOn))[/icode] To: [icode]IF (SELECT ReturnedOn FROM INSERTED) IS NULL[/icode]
Hi Bporajesh, This group is for MS SQL, most people here don't have knowledge about MySQL. If you post your question in the MySQL group, you probably get more help: [url]http://www.daniweb.com/forums/forum126.html[/url]
<div style="text-align:center;">this text will be in center, no mater what.</div>
There is a couple of unnecessary lines here. sql = "Insert Into veriler (name) Values ('"&name&"')" 'ADD sql = "Update veriler Set name='"&name&"' Where id=1" 'UPDATE sql = "Delete From veriler Where id=1" 'DELETE Here you will end up with only "Delete From veriler Where id=1" Because you replace the …
The End.