P Mistry
|
| Posted: 09/08/2002, 3:06 PM |
|
I'm working on a modified Support system, I need to list ALL posts made by a
particular user (email address).
I'm trying to create a grid to show users records where the Email address =
LOGIN user Email address.
I'm using access 2000 database
I've setup a search with allows me to show records where the email address
is manually typed in but I want to FILTER all posts by the email address of
the person logged in.
I can't seem to get this to work.
|
|
|
 |
CORNWELL
|
| Posted: 09/11/2002, 6:56 PM |
|
For ASP:
At login, make a session memvar for the user's email.
Something like....
Session("EmailAddr") = Dlookup("TableName", "Emailfieldname", ""LoginId =" &
ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
In the SQL for the listbox on the search form, use this Session memvar to
filter the selection for the listbox.
IN Form open: ThisEmail = Session("EmailAddr")
IN ListBox SQL:
SELECT IdField, TopicToShow FROM Tablename WHERE EmailFieldName = " &
ThisEmail & "
That's the process, sort out own syntax if I got it a bit wrong or if you're
not using ASP
HTH
Cornwell
"P Mistry" <pm@raksoft.co.uk> wrote in message
news:alghlv$1jv$1@news.codecharge.com...
> I'm working on a modified Support system, I need to list ALL posts made by
a
> particular user (email address).
>
> I'm trying to create a grid to show users records where the Email address
=
> LOGIN user Email address.
>
> I'm using access 2000 database
>
> I've setup a search with allows me to show records where the email address
> is manually typed in but I want to FILTER all posts by the email address
of
> the person logged in.
>
> I can't seem to get this to work.
>
>
>
|
|
|
|
P Mistry
|
| Posted: 09/12/2002, 9:01 AM |
|
First all THANK YOU for the help.
I've managed to sort of most of this but because the Search form has NO
ListBox SQL entry - I put the the following in the BEFORE open event.
sql = "SELECT case_id, description, summary, user_email, product_id,
status_id, priority_id FROM support_cases WHERE user_email = " & ThisEmail &
""
cn.execute sql
However, I get a browser error...
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'user_email =
pm@raksoft.co.uk'.
/support/usrCasesGrid.asp, line 463
What have I done wrong ??
"CORNWELL" <cornwell@tasmail.com> wrote in message
news:alos7h$ggk$1@news.codecharge.com...
> For ASP:
>
> At login, make a session memvar for the user's email.
> Something like....
> Session("EmailAddr") = Dlookup("TableName", "Emailfieldname", ""LoginId ="
&
> ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
>
> In the SQL for the listbox on the search form, use this Session memvar to
> filter the selection for the listbox.
> IN Form open: ThisEmail = Session("EmailAddr")
> IN ListBox SQL:
> SELECT IdField, TopicToShow FROM Tablename WHERE EmailFieldName = " &
> ThisEmail & "
>
> That's the process, sort out own syntax if I got it a bit wrong or if
you're
> not using ASP
>
> HTH
> Cornwell
>
> "P Mistry" <pm@raksoft.co.uk> wrote in message
>news:alghlv$1jv$1@news.codecharge.com...
> > I'm working on a modified Support system, I need to list ALL posts made
by
> a
> > particular user (email address).
> >
> > I'm trying to create a grid to show users records where the Email
address
> =
> > LOGIN user Email address.
> >
> > I'm using access 2000 database
> >
> > I've setup a search with allows me to show records where the email
address
> > is manually typed in but I want to FILTER all posts by the email address
> of
> > the person logged in.
> >
> > I can't seem to get this to work.
> >
> >
> >
>
>
|
|
|
|
CORNWELL
|
| Posted: 09/12/2002, 3:52 PM |
|
Hi
1. Did you correctly capture the email address into This Mail at login,?
Session("EmailAddr") = Dlookup("TableName", "Emailfieldname", ""LoginId ="
& ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
Check by - in form open. after above entry event place
response.write ThisEmail & "<br>"
to check the value is as expected.
2. Did you add in Form Open Event
ThisEmail = Session("EmailAddr")
That gets the value of the session memvar into the form code area
3. You appear to want to work over the recordset for a grid, filtering(
selecting) presenting in the grid only the records matching the email
address. You'd place your SQL statement in the Grid's FormProperties> SQL,
tick the SQL checkbox and place your statement there.
SELECT case_id, description, summary, user_email, product_id, status_id,
priority_id FROM support_cases WHERE user_email = '" & ThisEmail & "' ORDER
BY case_id, priority_id
Do not put opening or closing quotes around the string here, CC will do
that. when generating.
HTH
Cornwell.
"P Mistry" <pm@raksoft.co.uk> wrote in message
news:alqdo0$b0e$1@news.codecharge.com...
> First all THANK YOU for the help.
>
> I've managed to sort of most of this but because the Search form has NO
> ListBox SQL entry - I put the the following in the BEFORE open event.
>
> sql = "SELECT case_id, description, summary, user_email, product_id,
> status_id, priority_id FROM support_cases WHERE user_email = " & ThisEmail
&
> ""
> cn.execute sql
>
> However, I get a browser error...
>
> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression 'user_email =
>pm@raksoft.co.uk'.
> /support/usrCasesGrid.asp, line 463
>
> What have I done wrong ??
>
> "CORNWELL" <cornwell@tasmail.com> wrote in message
>news:alos7h$ggk$1@news.codecharge.com...
> > For ASP:
> >
> > At login, make a session memvar for the user's email.
> > Something like....
> > Session("EmailAddr") = Dlookup("TableName", "Emailfieldname", ""LoginId
="
> &
> > ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
> >
> > In the SQL for the listbox on the search form, use this Session memvar
to
> > filter the selection for the listbox.
> > IN Form open: ThisEmail = Session("EmailAddr")
> > IN ListBox SQL:
> > SELECT IdField, TopicToShow FROM Tablename WHERE EmailFieldName = " &
> > ThisEmail & "
> >
> > That's the process, sort out own syntax if I got it a bit wrong or if
> you're
> > not using ASP
> >
> > HTH
> > Cornwell
> >
> > "P Mistry" <pm@raksoft.co.uk> wrote in message
> >news:alghlv$1jv$1@news.codecharge.com...
> > > I'm working on a modified Support system, I need to list ALL posts
made
> by
> > a
> > > particular user (email address).
> > >
> > > I'm trying to create a grid to show users records where the Email
> address
> > =
> > > LOGIN user Email address.
> > >
> > > I'm using access 2000 database
> > >
> > > I've setup a search with allows me to show records where the email
> address
> > > is manually typed in but I want to FILTER all posts by the email
address
> > of
> > > the person logged in.
> > >
> > > I can't seem to get this to work.
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
P Mistry
|
| Posted: 09/13/2002, 4:39 AM |
|
Yes, I've done 1 & 2
I've also tried 3 - soon as I tick the SQL check box I get an error
Invalid SQL query
Error: No value given for one or more required parameters
"CORNWELL" <cornwell@tasmail.com> wrote in message
news:alr5s1$njg$1@news.codecharge.com...
> Hi
>
> 1. Did you correctly capture the email address into This Mail at login,?
> Session("EmailAddr") = Dlookup("TableName", "Emailfieldname", ""LoginId
="
> & ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
> Check by - in form open. after above entry event place
> response.write ThisEmail & "<br>"
> to check the value is as expected.
>
> 2. Did you add in Form Open Event
> ThisEmail = Session("EmailAddr")
> That gets the value of the session memvar into the form code area
>
> 3. You appear to want to work over the recordset for a grid, filtering(
> selecting) presenting in the grid only the records matching the email
> address. You'd place your SQL statement in the Grid's FormProperties>
SQL,
> tick the SQL checkbox and place your statement there.
>
> SELECT case_id, description, summary, user_email, product_id, status_id,
> priority_id FROM support_cases WHERE user_email = '" & ThisEmail & "'
ORDER
> BY case_id, priority_id
>
> Do not put opening or closing quotes around the string here, CC will do
> that. when generating.
>
> HTH
> Cornwell.
>
>
>
> "P Mistry" <pm@raksoft.co.uk> wrote in message
>news:alqdo0$b0e$1@news.codecharge.com...
> > First all THANK YOU for the help.
> >
> > I've managed to sort of most of this but because the Search form has NO
> > ListBox SQL entry - I put the the following in the BEFORE open event.
> >
> > sql = "SELECT case_id, description, summary, user_email, product_id,
> > status_id, priority_id FROM support_cases WHERE user_email = " &
ThisEmail
> &
> > ""
> > cn.execute sql
> >
> > However, I get a browser error...
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E14)
> > Syntax error (missing operator) in query expression 'user_email =
> >pm@raksoft.co.uk'.
> > /support/usrCasesGrid.asp, line 463
> >
> > What have I done wrong ??
> >
> > "CORNWELL" <cornwell@tasmail.com> wrote in message
> >news:alos7h$ggk$1@news.codecharge.com...
> > > For ASP:
> > >
> > > At login, make a session memvar for the user's email.
> > > Something like....
> > > Session("EmailAddr") = Dlookup("TableName", "Emailfieldname",
""LoginId
> ="
> > &
> > > ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
> > >
> > > In the SQL for the listbox on the search form, use this Session memvar
> to
> > > filter the selection for the listbox.
> > > IN Form open: ThisEmail = Session("EmailAddr")
> > > IN ListBox SQL:
> > > SELECT IdField, TopicToShow FROM Tablename WHERE EmailFieldName = " &
> > > ThisEmail & "
> > >
> > > That's the process, sort out own syntax if I got it a bit wrong or if
> > you're
> > > not using ASP
> > >
> > > HTH
> > > Cornwell
> > >
> > > "P Mistry" <pm@raksoft.co.uk> wrote in message
> > >news:alghlv$1jv$1@news.codecharge.com...
> > > > I'm working on a modified Support system, I need to list ALL posts
> made
> > by
> > > a
> > > > particular user (email address).
> > > >
> > > > I'm trying to create a grid to show users records where the Email
> > address
> > > =
> > > > LOGIN user Email address.
> > > >
> > > > I'm using access 2000 database
> > > >
> > > > I've setup a search with allows me to show records where the email
> > address
> > > > is manually typed in but I want to FILTER all posts by the email
> address
> > > of
> > > > the person logged in.
> > > >
> > > > I can't seem to get this to work.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
P Mistry
|
| Posted: 09/13/2002, 8:11 AM |
|
oops - spelling mistake.
Incorrect spelling of 'priority_id'
"P Mistry" <pm@raksoft.co.uk> wrote in message
news:alsiqe$ksh$1@news.codecharge.com...
> Yes, I've done 1 & 2
> I've also tried 3 - soon as I tick the SQL check box I get an error
>
> Invalid SQL query
> Error: No value given for one or more required parameters
>
> "CORNWELL" <cornwell@tasmail.com> wrote in message
>news:alr5s1$njg$1@news.codecharge.com...
> > Hi
> >
> > 1. Did you correctly capture the email address into This Mail at login,?
> > Session("EmailAddr") = Dlookup("TableName", "Emailfieldname", ""LoginId
> ="
> > & ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
> > Check by - in form open. after above entry event place
> > response.write ThisEmail & "<br>"
> > to check the value is as expected.
> >
> > 2. Did you add in Form Open Event
> > ThisEmail = Session("EmailAddr")
> > That gets the value of the session memvar into the form code area
> >
> > 3. You appear to want to work over the recordset for a grid, filtering(
> > selecting) presenting in the grid only the records matching the email
> > address. You'd place your SQL statement in the Grid's FormProperties>
> SQL,
> > tick the SQL checkbox and place your statement there.
> >
> > SELECT case_id, description, summary, user_email, product_id, status_id,
> > priority_id FROM support_cases WHERE user_email = '" & ThisEmail & "'
> ORDER
> > BY case_id, priority_id
> >
> > Do not put opening or closing quotes around the string here, CC will do
> > that. when generating.
> >
> > HTH
> > Cornwell.
> >
> >
> >
> > "P Mistry" <pm@raksoft.co.uk> wrote in message
> >news:alqdo0$b0e$1@news.codecharge.com...
> > > First all THANK YOU for the help.
> > >
> > > I've managed to sort of most of this but because the Search form has
NO
> > > ListBox SQL entry - I put the the following in the BEFORE open event.
> > >
> > > sql = "SELECT case_id, description, summary, user_email, product_id,
> > > status_id, priority_id FROM support_cases WHERE user_email = " &
> ThisEmail
> > &
> > > ""
> > > cn.execute sql
> > >
> > > However, I get a browser error...
> > >
> > > Error Type:
> > > Microsoft JET Database Engine (0x80040E14)
> > > Syntax error (missing operator) in query expression 'user_email =
> > >pm@raksoft.co.uk'.
> > > /support/usrCasesGrid.asp, line 463
> > >
> > > What have I done wrong ??
> > >
> > > "CORNWELL" <cornwell@tasmail.com> wrote in message
> > >news:alos7h$ggk$1@news.codecharge.com...
> > > > For ASP:
> > > >
> > > > At login, make a session memvar for the user's email.
> > > > Something like....
> > > > Session("EmailAddr") = Dlookup("TableName", "Emailfieldname",
> ""LoginId
> > ="
> > > &
> > > > ToSQL(sLogin, "Text") & " and Password=" & ToSQL(sPassword, "Text"))
> > > >
> > > > In the SQL for the listbox on the search form, use this Session
memvar
> > to
> > > > filter the selection for the listbox.
> > > > IN Form open: ThisEmail = Session("EmailAddr")
> > > > IN ListBox SQL:
> > > > SELECT IdField, TopicToShow FROM Tablename WHERE EmailFieldName = "
&
> > > > ThisEmail & "
> > > >
> > > > That's the process, sort out own syntax if I got it a bit wrong or
if
> > > you're
> > > > not using ASP
> > > >
> > > > HTH
> > > > Cornwell
> > > >
> > > > "P Mistry" <pm@raksoft.co.uk> wrote in message
> > > >news:alghlv$1jv$1@news.codecharge.com...
> > > > > I'm working on a modified Support system, I need to list ALL posts
> > made
> > > by
> > > > a
> > > > > particular user (email address).
> > > > >
> > > > > I'm trying to create a grid to show users records where the Email
> > > address
> > > > =
> > > > > LOGIN user Email address.
> > > > >
> > > > > I'm using access 2000 database
> > > > >
> > > > > I've setup a search with allows me to show records where the email
> > > address
> > > > > is manually typed in but I want to FILTER all posts by the email
> > address
> > > > of
> > > > > the person logged in.
> > > > >
> > > > > I can't seem to get this to work.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
