11 years ago

I blessed FP with my presence 11 years ago today. You’re welcome. :tearsofjoy:

I feel old.

{
“lightbox_close”: “Close”,
“lightbox_next”: “Next”,
“lightbox_previous”: “Previous”,
“lightbox_error”: “The requested content cannot be loaded. Please try again later.”,
“lightbox_start_slideshow”: “Start slideshow”,
“lightbox_stop_slideshow”: “Stop slideshow”,
“lightbox_full_screen”: “Full screen”,
“lightbox_thumbnails”: “Thumbnails”,
“lightbox_download”: “Download”,
“lightbox_share”: “Share”,
“lightbox_zoom”: “Zoom”,
“lightbox_new_window”: “New window”,
“lightbox_toggle_sidebar”: “Toggle sidebar”
}

Getting Old Baby Boomer GIF by MOODMAN

Applying for UK Visa but refused US visa 8 years ago on another named passport

I am applying for UK visa but I have been refused on US visa 8 years ago which was by my other name.

My name is very long so sometimes I use the short name and sometimes I use my full name. My first passport used my short name. I was refused a US visa. After a few years, I’ve gotten a new passport using my full name. My full name looks totally different from my short name. Hence, I am going to apply for UK visa now in my current full-named passport.

So I am worrying whether the UK embassy will find my US refused visa application details? if yes, what will they do? Will the fact that my previous passport used another name mean that it will be less likely that they’ll find it?

Should I let them know that I’ve used another passport 8 years ago for a US visa? or don’t say anything when I apply for the UK visa?

Comparing several years in excel line chart/diagramm

I want to compare several data values of several years over the course of a year. Something like this. For that, I changed all the data to be within the same year and I can put them in a graph together but unfortunately the data is not displayed accurate with the correct course. The problem is that I have different dates in each year and would like to display that in the chart that e.g. the 15th of a month is in between those month in the chart so you can distinguish.

When I plot them for each year, it is all fine, when I try to add another year in, you can see here that it doesn’t show it correctly.

An example on my table structure, it looks like this and I used the 00 year in combination with the value in my attempt to merge them.

I hope someone can help me

usa – 11 years Overstayed in the Philippines

My son got overstayed in the Philippines for 11 yrs and I want to bring him back here in US but I don’t know how much the fines by now. I don’t want to go to BI if I don’t have enough money to pay for the fines. Is anyone has an idea how much the fines cost? I’ll appreciate who will answer this.. thank you.

Also is it ok to travel in to Philippines now? What are the requirements to travel?

.eu Domains: Only €12 for 10 years, May 3rd to 12th!

LowEndTalk member @thedp shared news that registrar netim is offering a special price on .eu domains.

From May 3rd through May 12th, you can register a .eu domain for only €12 for 10 years!  That’s a pretty cheap domain offer.  Note this discount only applies to creations, not renewals or trustee service.

If you’re interested, read more on netim’s blog.

 

Related posts:

A Little Note on LowEndBox Domain (and Chance to Win 4VPS.com!)

raindog308

I’m Andrew, techno polymath and long-time LowEndTalk community Moderator. My technical interests include all things Unix, perl, python, shell scripting, and relational database systems. I enjoy writing technical articles here on LowEndBox to help people get more out of their VPSes.

I bought bitcoin years ago and now the website that I bought from is unavailable!

I bought bitcoin years ago and now the website that I bought from is unavailable!
I only have a key that I don’t even know whether it’s a public key or a private key or some useless key generated by the website. Plus I’m not sure that the website bought actual bitcoin or other cryptos for me.
How can I know if I have it on the blockchain?

I’m Arlene, from Philippines and I’m 29 years old.One way to make money online is through a website. You can place various ads on your site. | Proxies123.com

Hi, I’m Arlene, from Philippines and I’m 29 year old. One way to make money online is through a website. You can place various ads on your site that will earn money for you when they are viewed by visitors or for every time someone clicks on one of them. Usually, the more popular a site is, the more money it will earn for the site’s owner

 

usa – Can I get a hotel room in the US when I am 18 years old?

I live in Seattle, so I can safely say that you will have no problems booking a room. In the United States, you are legally an adult at 18 years of age. The only things you can’t do are drinking and gambling (you have to be 21 for those).

Some hotels might have a minimum age requirement, but that would be a rare exception. They may ask for a damage deposit, but you will get that deposit back when you check out. Many will also require you to book the room on a credit card before you arrive, but you can pay with any form of payment when you check-out. The credit card just holds the room and secures the damage deposit.

If you will be renting a car while you’re here, that’s a different story. Most car rental companies require you to be at least 25 years old. You need to make sure you have transportation when you get here, because you will likely not be able to get a car rental. Public transportation is reliable but slow and sparse outside the main downtown areas.

Also be prepared for heavy taxes. Seattle has a particularly high tourism tax, so expect to pay about 20% more than the room’s advertised rate.

powershell – Last year’s totals won’t group by hour

I have a PowerShell script with a query to display yesterday’s totals, as well as last year’s same day totals, by hour for comparison. Yesterday’s totals display by hour fine, but last year’s list the entire sum for each hour. Any pointers would be much appreciated. Thank you

”’
$sql1 = “

USE STORESQL
    
        SELECT FORMAT(TRS.F254, 'MM-d-yyyy') AS 'Date',


               'Time' = CASE 
                    WHEN TRS.F01 = 06 THEN '6 AM'
                     WHEN TRS.F01 = 07 THEN '7 AM'
                     WHEN TRS.F01 = 08 THEN '8 AM'
                     WHEN TRS.F01 = 09 THEN '9 AM'
                     WHEN TRS.F01 = 10 THEN '10 AM'
                     WHEN TRS.F01 = 11 THEN '11 AM'
                     WHEN TRS.F01 = 12 THEN '12 PM'
                     WHEN TRS.F01 = 13 THEN '1 PM'
                     WHEN TRS.F01 = 14 THEN '2 PM'
                     WHEN TRS.F01 = 15 THEN '3 PM'
                     WHEN TRS.F01 = 16 THEN '4 PM'
                     WHEN TRS.F01 = 17 THEN '5 PM'
                     WHEN TRS.F01 = 18 THEN '6 PM'
                     WHEN TRS.F01 = 19 THEN '7 PM'
                     WHEN TRS.F01 = 20 THEN '8 PM'
                     WHEN TRS.F01 = 21 THEN '9 PM'
                     WHEN TRS.F01 = 22 THEN '10 PM'
                     WHEN TRS.F01 = 23 THEN '11 PM'
               END,


               SUM(TRS.F65) AS 'Total Sales',

               
               (SELECT SUM(TRS.F65) FROM RPT_HOU AS TRS 
                JOIN TLZ_TAB TLZ ON TRS.F1034=TLZ.F1034
                JOIN LNK_TAB LNK ON TRS.F1056=LNK.F1056 and TRS.F1057=LNK.F1057
                WHERE TRS.F1031= 'D' AND 
                TRS.F254 BETWEEN '$startDateLastYear' and '$startDateLastYear' AND
                TRS.F1034 BETWEEN '2' and '2' AND
                TRS.F01 BETWEEN '08' and '22' AND
                LNK.F1000 NOT IN ('DSM', 'PAL', 'RAL', 'XAL')) AS 'Past Total Sales',


                SUM(TRS.F64) AS 'Transactions',

                   
               (SELECT SUM(TRS.F64) FROM RPT_HOU AS TRS 
                JOIN TLZ_TAB TLZ ON TRS.F1034=TLZ.F1034
                JOIN LNK_TAB LNK ON TRS.F1056=LNK.F1056 and TRS.F1057=LNK.F1057
                WHERE TRS.F1031= 'D' AND 
                TRS.F254 BETWEEN '$startDateLastYear' and '$startDateLastYear' AND
                TRS.F1034 BETWEEN '2' and '2' AND
                TRS.F01 BETWEEN '08' and '22' AND
                LNK.F1000 NOT IN ('DSM', 'PAL', 'RAL', 'XAL')) AS 'Past Transactions',



               (round(SUM(TRS.F65)/SUM(TRS.F64), 2)) AS 'Avg Basket Size',



               (SELECT(round(SUM(TRS.F65)/SUM(TRS.F64), 2)) FROM RPT_HOU AS TRS 
                JOIN TLZ_TAB TLZ ON TRS.F1034=TLZ.F1034
                JOIN LNK_TAB LNK ON TRS.F1056=LNK.F1056 and TRS.F1057=LNK.F1057
                WHERE TRS.F1031= 'D' AND 
                TRS.F254 BETWEEN '$startDateLastYear' and '$startDateLastYear' AND
                TRS.F1034 BETWEEN '2' and '2' AND
                TRS.F01 BETWEEN '08' and '22' AND
                LNK.F1000 NOT IN ('DSM', 'PAL', 'RAL', 'XAL')) AS 'Past Avg Basket Size'



    
        FROM RPT_HOU AS TRS 
                JOIN TLZ_TAB TLZ ON TRS.F1034=TLZ.F1034
                JOIN LNK_TAB LNK ON TRS.F1056=LNK.F1056 and TRS.F1057=LNK.F1057

        WHERE TRS.F1031= 'D' AND 
                TRS.F254 BETWEEN '$startDate' and '$startDate' AND
                TRS.F1034 BETWEEN '2' and '2' AND
                TRS.F01 BETWEEN '08' and '22' AND
                LNK.F1000 NOT IN ('DSM', 'PAL', 'RAL', 'XAL')

        GROUP BY TRS.F254, TRS.F01
        ORDER BY TRS.F254

"

”’

Output:

enter image description here

Last time I post here was ten years ago

Advertising

y u no do it?

Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

Starts at just $1 per CPM or $0.10 per CPC.