jjmusicpro

I am using MSSQL thats what they have installed not MYSQL. SO any ideas? Strange....... This works SELECT * FROM Table WHERE Date BETWEEN '11/10/2008' AND '12/25/2009' SELECT * FROM Table WHERE Date BETWEEN '12/10/2008' AND '12/25/2009' BUt it only brings back stuff from 2008 NOT 2009 This does not work SELECT * FROM Table WHERE Date BETWEEN '11/10/2008' AND '1/25/2009' If I run this SELECT * FROM Table WHERE Date BETWEEN '1/1/2009' AND '12/25/2009' It brings back ALL records, and this is wrong.

For example if i run this SELECT * FROM Table WHERE Date BETWEEN '12/10/2008' AND '12/23/2008' It works, however if I run this SELECT * FROM Table WHERE Date BETWEEN '12/10/2008' AND '12/23/2009' I bring Back NO records

Hi, I was running a date query and it seems my 2008 querys work, however when i look at 2009 querys, it goes back in time. SELECT TOP 1 * FROM Table where P1Name='Billy Jones'and Date BETWEEN '12/21/2008' AND '1/9/2009' ORDER BY Date DESC

sorry that dosent help, ive looked at that. do i have to compare dates first, then compare time?

well i can get both the dates fine, i just dont know the syntax to check a range of "time" and count the mount of records. Ive done it for days, but not for hours

I have a program that checks the inputs of a form. IN the database i input a time/date stamp of when these took place, plus the IP they came from. I dont want someone to do more then 3 requets and hour. Can I check the amout of records using a SQL query? or do i have to do it in code. I know i can check a day range, but neve tried hours.

they are varchars

I have 2 columns in a database, date, and time that looks like this column 1 column 2 1/1/09 10:32AM 1/1/09 10:35AM 1/5/09 12:32AM how can i write a query to get the latest phone call made ? i tried max but i didnt work. I wanted it to get the latest time, for each day

I have a flash chat that takes some time to get loaded since the data is displayed from the database.. I wanted to display the page, and then when the flashloads, display that. Or display some icon like a ajax image, saying loading...then have it popup when its fully loaded... right now, my page waits until the page is all the way done loading everything before displaying.

im running my php against a mssql db

I have a text box, that someone can type in anything they want, however if they type in what's or any ' it will break the insert anyways to get around this?

im calling the vbscript from my php page

i need to convert it in my vbscript

i tried that, i am pulling this value from a database, and it comes out as 16:46 09/19/2008

I have a date in this format 16:46 09/19/2008 and i want to convert it to normal time... i i have a huge vb script hat i am running, and need to know how to convert that to just normal time lol

i mean i can use either or right? just classes can be made abstract etc.

what is the difference?

wouldnt it be like this?> function enterinto(arg1, arg2) { //do something } enterinto("one", "two");

i was wondering how to do i make another function in my php script, then call it later int he script? so i have a function called enterinto ssrpm... Then i wanted to call that later with some paramaters.

Yeah, but that makes the server do it, not the browser. How about we start at the root of the question? What exactly do you want to do this for, and be specific. Maybe cURL is what im looking for. I wanted to have a page that has "title" and "body" check box's. Then i fill those in, hit submit, and it will go to some other website that has those fields on the page, it puts those values into that page, hits the submit on that page, and then search the results page for "your post has been submitted", or something in the return text. Then put "worked" if it found that text in the respone, or "not worked" if it didnt find text. Hope that helps.

there has to be some way or function to go to another page in your code, fill in some text box's on that virtual page, and then hit enter on that page, all without the user seeing the browser do it.

Ive looked through the ajax turtorials... ok say im not going to do this in AJAX I want to make a page where i put in some data, it send that data to another page, where the code in that page, actually goes to another site, and puts in the data, and presses "submit" just as if i were to go to that page and do it.

I wanted to make a page where you put in details like, title, description etc. and hit go.. Then it will send that data to some ajax page that will post this data say into a forum etc. I dont know how to navigate pages without it changing the main page.

I have an insert statment where someone can put in text like - Hell it's a nice day. anytime anyone does a ' it breaks my code what is the escape clase for this?

In you insert statment are you using now() to get date? What is the column type you are adding this date field to>?