Battling to find scripts
-
Morning guys.Im looking for a script I can use with a database.I have a database with people's birthdates, so I need to compare that database date with a system date and if the dates match print the details of the people that celebrates. My lil immature script looks like this. ") end if rs.close set rs = nothing end if %>]]>
kagiso
-
Morning guys.Im looking for a script I can use with a database.I have a database with people's birthdates, so I need to compare that database date with a system date and if the dates match print the details of the people that celebrates. My lil immature script looks like this. ") end if rs.close set rs = nothing end if %>]]>
kagiso
Dude, your script makes very little sense, calling functions that we can't see, using variables that we don't know how they are initialised. What do you actually need? A SQL script that selects from a table based on a date?
SELECT * FROM ATable WHERE ADate = GetDate()Would work in SQL Server...