Short term engagement (job) at USC Marshall School of Business
USC Marshall School of Business is seeking someone with SQL experience to diagnose and repair some Stored Procedures that are failing. This is a short term gig, not a position opening.
I don't have all the details but from what I understand, there are some stored procedures and some are working and some are not. It sounds like there isn't any error handling to make sure that one procedure finishes before moving on to the next, or to throw an error if something fails.
Read moreProblem with SQL statement in Views D7
Hi there, I'm hoping a SQL ninja will find it in his or her heart to provide me with some advice.
I've created a page view which does the following:
- Pulls in nodes from two different content types
- Filters by two different term references, one for each content type.
It's not working, although in my mind (and limited sql understanding), it should. I think maybe there's an issue with the inner joins, because it seems the sql statement would working if they weren't there.
Anyways, I've attached two images, one of the api and one of the actual sql statement.
Read moreHow can I explain SQL injection without technical jargon?
An interesting question on the Security Stack Exchange, with a clever answer. Give it a look and be more prepared the next time your boss asks you why your code just cost the company two million dollars.
Read moreCoder Needed
Hi Guys,
I need someone to coder a script that will use PHP to update a database table with one database with a particular record form another Database table.
I have tried and failed, mainly because I lack time.
Need a coder to do this and need to know the cost.
Also this script will be use to an Adult site.
Thank you guys and looking forward to some help soon.
Read moreMigrar de Drupal 7 a Pressflow, ¿Cómo hago?
Hola, nuevamente tengo una alta carga en mi sitio y veo demasiados procesos en mi servidor. Aunque he activado la opción cache, hay momentos de mucho tráfico y luego aparece en rojo http, cpanel, sql, etc, y finalmente el mensaje de Apache y el colapso del servidor. Me recomendaron Pressflow y Varnish. Mis dudas son: ¿Puedo migrar mis 20 mil nodos de Drupal 7 a PressFlow, que módulo o herramienta uso? ¿Sólo necesito bajar Pressflow y hacer correr el server o debo instalar Varnish en mi servidor? ¿Es cierto que esas herramientas impiden usar el contador de hits de mi sitio y algunas vistas?
Read moreCan Drupal Do This??
Hi,
I am very new to Drupal and been searching some features which i need to be on my site.
1- I have my own database on my site which is mini Apps , its about Indoor sports where i have players,tournaments,matches , i have this site up and running , Now when i came know to Drupal , i am willing to make a site on Drupal , but i am worried how i am gonna show all my existing data in Drupal ,. in SHORT is there any modules which can run my queries and display results in tables, i have also a mode which compares all players performance using information in my data base.
Read moreTimed-Out Presentation - Views, Dates and Arguments
I was scheduled for a Lighting Talk last night, but the group ran out of time before we got there. The talk was titled "Views, Dates, and Arguments". It concerns a (known) bug I encountered in the Dates module when working with Views and Arguments. A discussion of the issue and my slides are on my blog at http://realism.com/blog/views-dates-and-arguments.
After Dark I discussed this with Ashok. He had encountered this error in the Spring and used the patch fix. I welcome further discussion here about recommended solutions.
Read moreDiscussion of advertising guidelines
Update: This has become a discussion about advertising guidelines on g.d.o/australia (perhaps generally as well).
Original Title: Expert Web Development Training in HTML, CSS, JavaScript, PHP, MySQL and Drupal
Hi, my name is Shaun Moss, and I provide 3 main services: Web Development, Consulting and Training. Today I want to tell you about my training services.
Web Development Training
Read moreSQL ICE Demo for Drupal Users - Link to Webinar Video & Queries
Thank you to those who attended our webinar this week, and thanks for the positive feedback we received.
As promised, here is a link where you will find the recording of the session. We have also provided the query examples as a .zip that you can download. SQL ICE has an import function that you can use to pull these examples into your local SQL ICE.
http://businessintegrationtechnology.com/SQLICE_Videos.html
Feel free to contact me if you need anything.
Lori Folta
lfolta@businessintegrationtechnology.com
Trouble with some SQL core code
Hi Guys/Gals,
Read more