reset password
Author Message
ccruz58
Posts: 16
Posted 21:04 Feb 27, 2015 |

For the homework, what does it mean to not hard code the ids? 

tbooker
Posts: 20
Posted 21:11 Feb 27, 2015 |

Don't put in any actual values for ids (memberid, artistid, etc.)

aaleman11
Posts: 42
Posted 21:12 Feb 27, 2015 |

I believe he means to make sure you use subqueries. For example, let's say you do a max(whatever) and the result is 10. Hard coding it would mean your query would have something like:

WHERE whatever = 10;

as opposed to 

WHERE = (SELECT max(whatever) FROM something);

I think that's what he means. I could be wrong, but my gut feeling tells me he's just instructing use to use no other method but subqueries.

ccruz58
Posts: 16
Posted 21:13 Feb 27, 2015 |

dont put the id's when writing the queries? How? There's other ways of writing the queries?

ccruz58
Posts: 16
Posted 21:14 Feb 27, 2015 |

oh i see what you mean. example: dont put memberid = "3"

ccruz58
Posts: 16
Posted 21:15 Feb 27, 2015 |

do we have to give explanations for the queries?

aaleman11
Posts: 42
Posted 12:12 Mar 02, 2015 |

I don't think we have to explain it. It doesn't say on the homework.