Ben Howard x Lana Del Rey | "Video Games" (Cover) - A64 [S5.EP1]: SBTV

[Outer limits, Supervelocity, Space Pattern & Beyond] Operation Interste...

Shutdown or Restart Computer on a Schedule: Win Vista/7

General error: 1364 Field 'id' doesn't have a default value

Hi!

The id you defined for your entity is not identity. It must be!

Good luck!

Error: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

SQL Query:

INSERT INTO projetos (user_id, nome) VALUES (:c0, :c1)

Transform SELECT INTO HTML / XML / SQL SERVER / td=

Hi!

I have to say this is a little bit too hermetic for me, but it works.

This is an example of how to transform a SELECT into  HTML format.

Notice that it shows how to add color to each cell (td).

This example is priceless.

If you have any doubt, leave a comment.

Good luck!

SET @html = 

cast((

select

      td=NICK,'',

      td=REPLACE(RTRIM(CONVERT(CHAR(15) , CAST(unit AS MONEY) ,1)),'.00',''), '',

      td=RTRIM(CONVERT(CHAR(15) , CAST(sale AS MONEY) ,1)),'',

      td=REPLACE(RTRIM(CONVERT(CHAR(15) , CAST(TICKETS AS MONEY) ,1)),'.00',''), '',

      td=REPLACE(RTRIM(CONVERT(CHAR(15) , CAST(FLUXO AS MONEY) ,1)),'.00',''), '',

      td=PA, '',

      td=TM, '',

      td=CONVER, '',

      cast(case when GOAL_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=GOAL_P, '',

      cast(case when UNIT_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),UNIT_LY_DAY_P), '',

      cast(case when SALE_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),SALE_LY_DAY_P ),'',

      cast(case when TICKETS_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),TICKETS_LY_DAY_P), '',

      cast(case when FLUXO_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),FLUXO_LY_DAY_P), '', 

      cast(case when PA_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),PA_LY_DAY_P), '', 

      cast(case when TM_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),TM_LY_DAY_P), '', 

      cast(case when CONVER_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,1),CONVER_LY_DAY_P),''

FROM [table]

WHERE field LIKE '??%'

ORDER BY convert(numeric(11,1),GOAL_P) DESC

FOR XML path('tr'),type) as nvarchar(max))

+'</table>'

IMPORTANT/ BAD, BAD, REALLY BAD **** COURSERA WIPED ALL ALL MY CERTIFICATES AND MY PREVIOUS ACTIVITIES

Do you know COURSERA?

Well let tell you something. Today, I logged in, and all my certificates were gone, for good.

That's the message I wrote to them.


Hi!
All my certificates are gone.
All my activities were erased.
What are you doing?
Do you have any idea of how many hours I dedicated to earn those certificates?
My account was completed wiped out.
When we start a course, there's a code of honor to follow. Are you following any code of honor?
If you are a honorable organization, you will find out what happened.
Even the certificates that were linked to my linked in account were deleted.
What's wrong with you guys?
I have seen people and organizations loosing face, but you are by far the worst example.
I will not write regards in the end of this message, because I just know how to finish this.

Yes, I know, I was a little bit dramatic. But I'm not overreacting. I did spend a lot of hours of studying to get my certificates. My data science certificates are gone, and they pretty hard to achieve.

This is was my biggest disappointments in years concerning to an institution.

This is sad. Really sad.

cakephp 3 installation issue - unexpected T_OBJECT_OPERATOR in config/bootstrap.php on line 107

Hi!

You have just deployed your applicaton and you received this error

unexpected T_OBJECT_OPERATOR
?

Don't worry, it's the version of your PHP.

I changed from 5.3 to 5.5.

Yeah, I have no time keep investigating, so I decided to go to 5.5.

It worked.

Good Luck!