Hi All!
I have 1 database with 2 tables (users, purch). I need to query table 'users' and match on field users.referer and in purch I need match when total_amount > 0 and purch_date is between start_date and end_date and from there I need the sum total of 4 columns from purch for each day...
Hey All!
I'm working on a report and I can't seem to get my head around this (not being a true vb/vbs coder makes it a little harder).
I have a table which contains 3 fields (id, fname, fdate)
id = person accessing
fname = file name accessed
fdate = date of file access
I need to create a MTD...
I have a database I have a table where one of the fields (afl_url) contains a URL.
In another database I have a table wherein the records MAY contain a field which may have a matching URL (I only need up to the .com part)
I am trying to do MTD and YTD queries from the 2nd database where the...
I'm a web developer not an access developer so pardon the ignorance behind these questions:
I have an access database, can I create an access report and call it from an ASP page?
If so, can anyone provide me with an example or point to an example?
Thanks,
Phil
I've screwed around with this for two hours and can't get this javascript function to get called! I must be missing something here! Extra eyes would be GREATLY appreciated!
Here is my html code:
<html>
<head>
<link rel="StyleSheet" href="/javascript/coolstyle.css" type="text/css">
<script...
Hey All!
I need some brain power here!
I am developing an affiliate program where sites (like this one) can sign up and as an affiliate place a banner on their site and then get paid on sales of products made as a result of the click-through (a site could make about $125 per sale).
What I...
I have a header file called (*gasp*) header.js which gets included in ALL my pages (asp and plain htm).
This header file checks some variables and if appropriate it then outputs the needed html strings.
Here are the variables"
var showdate = "yes" // SHOW DATE AT THE TOP
var showsearch =...
Hey Gang!
Would someone kindly help me understand this little problem:
'See if this is a single system purchase
u1 = Trim(Request.Form("q1"))
If u1 = 0 Then
'If we got here, we are looking for quantity purchases
u2 = Trim(Request.Form("q2")) 'This would be the starter pak
If u2 = 0...
After my last post here revealed and educated me about SQL Injection issues I have been trying to convert my old style code to ado.net and I can't seem to get this right! I'm sure there are tons of errors in this sample (SO NO LAUGHING! - LOL)
Please help...
----------- code sample ----------...
Hi Guys! This one is stumping me!
I have an account sign-up form (code at the bottom of this post) which calls an asp page which would read the form, build a SQL insert string and insert the new record into a table. I was originally getting a SQL error for trying to submit a blank field. In my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.