RalphCapper.euThe resource for Web People - Design, Development and SEONegative values appeared in an int field of my table- June 17, 2008 A curious problem just cropped up on one of our sites. An allowance field (int) was negative in almost all records of a table. Different negative numbers, but many the same, like -32, -16, etc. Some head scratching later revealed a bit of SQL like this: ' Reduce allowance sql = "UPDATE myTable SET allowance = ...http://www.ralphcapper.eu/2008/negative-values-appeared-in-an-int-field-of-my-table/ SQL - select items from table X that are NOT present in table Y- June 12, 2008 What&8217;s the easiest way to select items from X that are NOT present in Y e.g. In X we have ID, Name 1, Bob; 2, Rita; 3, Sue In Y we have ID, Name 2, Rita So we want a result set of Bob; Sue My solution is: SELECT X.ID, Y.Name FROM X WHERE X.Name NOT IN ( SELECT Y.Name FROM Y WHERE Y.Name ...http://www.ralphcapper.eu/2008/sql-select-items-from-table-x-that-are-not-present-in-table... Reading attributes of nodes in an RSS feed with ASP VBScript- June 2, 2008 If you parse an RSS feed (see http:www.ralphcapper.eu2007classic-asp-xml-feed-reader) you may miss essential values that are set as attributes of a node, rather than an entity you can access with xmlItem.childNodes. &60;item &60;titleHelo World&60;title &60;hello:content foo="bar" url="http:myurl"&60;hello:content &60;item One solution is to loop through each item like so: For Each xmlItem In xmlList For Each xmlItem2 In xmlItem.childNodes if xmlItem2.nodeName = "hello:content"...http://www.ralphcapper.eu/2008/reading-attributes-of-nodes-in-an-rss-feed-with-asp-vbscrip... Update your website with Twitters and Scheduled Tasks in ASP VBScript- June 2, 2008 If you can convince people to use twitter, then you can use the service to automatically update your site, perhaps your own blogs Or, you could use them to upload to your main Twitter account. I haven&8217;t implemented the second of those yet, but the first is pretty easy: url = "RSS-feed-of-twitter&8221; &8216; e.g. ...http://www.ralphcapper.eu/2008/update-your-website-with-twitters-and-scheduled-tasks-in-as... |