User Profile

Collapse

Profile Sidebar

Collapse
cadab
cadab
Last Activity: Apr 1 '11, 04:43 PM
Joined: Aug 26 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • cadab
    started a topic Batch new line variable

    Batch new line variable

    I have a txt file that contains a few lines of data, i also have a for loop that extracts this data into one variable, i then email this variable using 'blat'. The problem is, the extracted data consists on one line, and i need to be able to email this in a more coherent form, i.e. having each line in the text file displayed in the email in the same way(with new lines).

    I've tried playing around with adding '\n' to the variable but...
    See more | Go to post

  • cadab
    replied to URL to thumbnail
    http://www.thumbalizr.com/ is another one i've just found, has a free api, this is probably your best bet.
    See more | Go to post

    Leave a comment:


  • cadab
    replied to URL to thumbnail
    yeah, i've just tried a few non popular sites, you may need to register first?
    See more | Go to post

    Leave a comment:


  • cadab
    replied to URL to thumbnail
    could a website like this help?

    http://www.websnapr.com/

    or one similar? i presume you would want this to be automatic?

    edit: You can alter the url, not sure of the ToS for that site.
    e.g. http://images.websnapr.com/?url=byte...e=s&nocache=15...
    See more | Go to post
    Last edited by cadab; Oct 21 '09, 11:42 AM. Reason: added info

    Leave a comment:


  • cadab
    started a topic data grid view, show selected columns

    data grid view, show selected columns

    I have a data grid view, i have specified several columns through the designer that i would like to show on the grid, i have mapped them to the datasource, this works fine, the problem is, my data source contains lots of columns and some of these i do not want to show on the grid.

    Is there a property/option where i can just get my specified columns to show, without resorting to removing each column programticly.

    Thanks,...
    See more | Go to post

  • cadab
    started a topic Using Joins

    Using Joins

    I've got two tables, customers and license, i am trying to run a query that will get the customer and license data, the two tables both have a matching customer ID. One customer ID can be in the license db several times, i.e. for trial and suspended licenses.

    I want to be able to get the customer details with the most recent license aswell, i.e. get the license that has the latest expiry date.

    Thanks,
    James
    See more | Go to post

  • cadab
    started a topic How to use not equal to

    How to use not equal to

    I'm trying to include a not equal to in the following statement so the specified ClientID is not returned.

    Code:
    SELECT LocationId, ClientID, X, Y, Z, Longitude, Latitude, EntryTime, MAX(EntryTime) as DateTime FROM tmcclientlocation GROUP BY EntryTime
    Thanks,

    James
    See more | Go to post
No activity results to display
Show More
Working...