[Zope-CMF] using a sql method in plone..

chris larsen chris@silentcooperative.com
Sat, 3 Aug 2002 17:39:51 -0700


This is a multi-part message in MIME format.

------=_NextPart_000_001F_01C23B14.C58FDE40
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Could someone please give me an explanation on how the user profile
(user id) is referred to so I can associate it with a sql column to be
inserted/selected as?  For example, if the username is "chris", how
would I view all of the data in a table that has to do with that user
id?   Such as;
 
Select * from table where userid="chris";
 
I want to enable each person to only see/modify their record(s) in the
table.  Seems like a pretty simple question??
 
Any simple way of doing this with CMF/plone or should I just use a
unique id and have them enter their name to pull that record.  One thing
is that I'm concerned about other people guessing and pulling up other
names to then modify.  Hrmmmm.
 
Thanks,
Chris

------=_NextPart_000_001F_01C23B14.C58FDE40
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">


<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C23B14.C5514EA0">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;
	text-underline:single;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	mso-style-noshow:yes;
	mso-ansi-font-size:10.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:Arial;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:windowtext;}
span.SpellE
	{mso-style-name:"";
	mso-spl-e:yes;}
span.GramE
	{mso-style-name:"";
	mso-gram-e:yes;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */=20
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
</style>
<![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Could someone please give me an explanation on how =
the user
profile (user id) is referred to so I can associate it with a <span
class=3DSpellE>sql</span> column to be inserted/selected as? <span
style=3D'mso-spacerun:yes'>&nbsp;</span>For example, if the username is =
&#8220;<span
class=3DSpellE>chris</span>&#8221;, how would I view all of the data in =
a table
that has to do with that user id? <span
style=3D'mso-spacerun:yes'>&nbsp;&nbsp;</span>Such =
as;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Select * from table where <span =
class=3DSpellE>userid</span>=3D&#8221;<span
class=3DSpellE>chris</span>&#8221;;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I want to enable each person to only see/modify their
record(s) in the table.<span style=3D'mso-spacerun:yes'>&nbsp; =
</span>Seems like
a pretty simple question??<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><span class=3DGramE><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Any simple way of doing =
this with
CMF/<span class=3DSpellE>plone</span> or should I just use a unique id =
and have
them enter their name to pull that record.</span></font></span><font =
size=3D2
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'> <span
style=3D'mso-spacerun:yes'>&nbsp;</span>One thing is that I&#8217;m =
concerned
about other people guessing and pulling up other names to then =
modify.<span
style=3D'mso-spacerun:yes'>&nbsp; =
</span>Hrmmmm&#8230;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Chris<o:p></o:p></span></font></p>

</div>

</body>

</html>

------=_NextPart_000_001F_01C23B14.C58FDE40--