studycode

I am trying to run a delete statement in mysql - I get an error. To test I tried running it as "select *" instead of "delete". Nothing else changed, and it runs fine. Any idea why?

here is the full delete statement

I have two tables. I want to perform SQL join, but not able to figure out how to achieve my requirement. Below are my scenarios and the result I want.

Scenario-1

CountryDetails table-

I am using multiple OR conditions in my find function, but cakephp overrides it and takes only the latest OR condition, which is very disturbing. Each or conditions focus a different table. This is my custom find function:

I am having a strange behavior which I do not understand with my cakephp 2. In my Model 'Study' I have a has many relation:

Is it possible to retrieve records where the index is the record id?

I have a model with a hasMany Relation. So my study can have multiple texts and questions etc.

The custom retrieve function looks like this:

I am new to ggplot2 (and R) and am trying to make a filled bar chart with labels in each box indicating the percentage composing that block.

Here is an example of my current figure to which I would like to add labels:

In MS-SQL Server, is it possible to pass a parameter to a DEFAULT function, or somehow base the DEFAULT value on the values inserted in the record?

You can assign a function as a DEFAULT value for a column in MS-SQL Server. Using this, I'm trying to achieve the following. For a table with study ids and patient ids, I want to automatically assign a new patient number within that study.