<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <%'check to see if signup button is pressed If (Request("signup") <>"") Then End If %> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryString End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form2") Then MM_editConnection = MM_iaminawe_data_STRING MM_editTable = "Contacts" MM_editRedirectUrl = "index.asp?signup=affirmative" MM_fieldsStr = "textFrom|value" MM_columnsStr = "Email|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> <% Dim RS_CurrentEvents Dim RS_CurrentEvents_numRows Set RS_CurrentEvents = Server.CreateObject("ADODB.Recordset") RS_CurrentEvents.ActiveConnection = MM_iaminawe_data_STRING RS_CurrentEvents.Source = "SELECT * FROM News ORDER BY itemid DESC" RS_CurrentEvents.CursorType = 0 RS_CurrentEvents.CursorLocation = 2 RS_CurrentEvents.LockType = 1 RS_CurrentEvents.Open() RS_CurrentEvents_numRows = 0 %> <% Dim RS_Webwork Dim RS_Webwork_numRows Set RS_Webwork = Server.CreateObject("ADODB.Recordset") RS_Webwork.ActiveConnection = MM_iaminawe_data_STRING RS_Webwork.Source = "SELECT * FROM Work" RS_Webwork.CursorType = 0 RS_Webwork.CursorLocation = 2 RS_Webwork.LockType = 1 RS_Webwork.Open() RS_Webwork_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 5 Repeat1__index = 0 RS_CurrentEvents_numRows = RS_CurrentEvents_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim RS_CurrentEvents_total Dim RS_CurrentEvents_first Dim RS_CurrentEvents_last ' set the record count RS_CurrentEvents_total = RS_CurrentEvents.RecordCount ' set the number of rows displayed on this page If (RS_CurrentEvents_numRows < 0) Then RS_CurrentEvents_numRows = RS_CurrentEvents_total Elseif (RS_CurrentEvents_numRows = 0) Then RS_CurrentEvents_numRows = 1 End If ' set the first and last displayed record RS_CurrentEvents_first = 1 RS_CurrentEvents_last = RS_CurrentEvents_first + RS_CurrentEvents_numRows - 1 ' if we have the correct record count, check the other stats If (RS_CurrentEvents_total <> -1) Then If (RS_CurrentEvents_first > RS_CurrentEvents_total) Then RS_CurrentEvents_first = RS_CurrentEvents_total End If If (RS_CurrentEvents_last > RS_CurrentEvents_total) Then RS_CurrentEvents_last = RS_CurrentEvents_total End If If (RS_CurrentEvents_numRows > RS_CurrentEvents_total) Then RS_CurrentEvents_numRows = RS_CurrentEvents_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (RS_CurrentEvents_total = -1) Then ' count the total records by iterating through the recordset RS_CurrentEvents_total=0 While (Not RS_CurrentEvents.EOF) RS_CurrentEvents_total = RS_CurrentEvents_total + 1 RS_CurrentEvents.MoveNext Wend ' reset the cursor to the beginning If (RS_CurrentEvents.CursorType > 0) Then RS_CurrentEvents.MoveFirst Else RS_CurrentEvents.Requery End If ' set the number of rows displayed on this page If (RS_CurrentEvents_numRows < 0 Or RS_CurrentEvents_numRows > RS_CurrentEvents_total) Then RS_CurrentEvents_numRows = RS_CurrentEvents_total End If ' set the first and last displayed record RS_CurrentEvents_first = 1 RS_CurrentEvents_last = RS_CurrentEvents_first + RS_CurrentEvents_numRows - 1 If (RS_CurrentEvents_first > RS_CurrentEvents_total) Then RS_CurrentEvents_first = RS_CurrentEvents_total End If If (RS_CurrentEvents_last > RS_CurrentEvents_total) Then RS_CurrentEvents_last = RS_CurrentEvents_total End If End If %> <% Dim MM_paramName %> <% ' *** Move To Record and Go To Record: declare variables Dim MM_rs Dim MM_rsCount Dim MM_size Dim MM_uniqueCol Dim MM_offset Dim MM_atTotal Dim MM_paramIsDefined Dim MM_param Dim MM_index Set MM_rs = RS_CurrentEvents MM_rsCount = RS_CurrentEvents_total MM_size = RS_CurrentEvents_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Validate request to log in to this site. MM_LoginAction = Request.ServerVariables("URL") If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString) MM_valUsername=CStr(Request.Form("user")) If MM_valUsername <> "" Then MM_fldUserAuthorization="" MM_redirectLoginSuccess="../../admin/index.asp" MM_redirectLoginFailed="index.asp" MM_flag="ADODB.Recordset" set MM_rsUser = Server.CreateObject(MM_flag) MM_rsUser.ActiveConnection = MM_iaminawe_data_STRING MM_rsUser.Source = "SELECT Username, Password" If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization MM_rsUser.Source = MM_rsUser.Source & " FROM Logins WHERE Username='" & Replace(MM_valUsername,"'","''") &"' AND Password='" & Replace(Request.Form("password"),"'","''") & "'" MM_rsUser.CursorType = 0 MM_rsUser.CursorLocation = 2 MM_rsUser.LockType = 3 MM_rsUser.Open If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then ' username and password match - this is a valid user Session("MM_Username") = MM_valUsername If (MM_fldUserAuthorization <> "") Then Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value) Else Session("MM_UserAuthorization") = "" End If if CStr(Request.QueryString("accessdenied")) <> "" And false Then MM_redirectLoginSuccess = Request.QueryString("accessdenied") End If MM_rsUser.Close Response.Redirect(MM_redirectLoginSuccess) End If MM_rsUser.Close Response.Redirect(MM_redirectLoginFailed) End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter if (Not MM_paramIsDefined And MM_rsCount <> 0) then ' use index parameter if defined, otherwise use offset parameter MM_param = Request.QueryString("index") If (MM_param = "") Then MM_param = Request.QueryString("offset") End If If (MM_param <> "") Then MM_offset = Int(MM_param) End If ' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' move the cursor to the selected record MM_index = 0 While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1)) MM_rs.MoveNext MM_index = MM_index + 1 Wend If (MM_rs.EOF) Then MM_offset = MM_index ' set MM_offset to the last possible record End If End If %> <% ' *** Move To Record: if we dont know the record count, check the display range If (MM_rsCount = -1) Then ' walk to the end of the display range for this page MM_index = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size)) MM_rs.MoveNext MM_index = MM_index + 1 Wend ' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = MM_index If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If End If ' if we walked off the end, set the offset based on page size If (MM_rs.EOF And Not MM_paramIsDefined) Then If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then If ((MM_rsCount Mod MM_size) > 0) Then MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Requery End If ' move the cursor to the selected record MM_index = 0 While (Not MM_rs.EOF And MM_index < MM_offset) MM_rs.MoveNext MM_index = MM_index + 1 Wend End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record RS_CurrentEvents_first = MM_offset + 1 RS_CurrentEvents_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (RS_CurrentEvents_first > MM_rsCount) Then RS_CurrentEvents_first = MM_rsCount End If If (RS_CurrentEvents_last > MM_rsCount) Then RS_CurrentEvents_last = MM_rsCount End If End If ' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth Dim MM_removeList Dim MM_item Dim MM_nextItem ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next ' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links Dim MM_keepMove Dim MM_moveParam Dim MM_moveFirst Dim MM_moveLast Dim MM_moveNext Dim MM_movePrev Dim MM_urlStr Dim MM_paramList Dim MM_paramIndex Dim MM_nextParam MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 1) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then MM_paramList = Split(MM_keepMove, "&") MM_keepMove = "" For MM_paramIndex = 0 To UBound(MM_paramList) MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1) If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If ' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = MM_keepMove & "&" End If MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = MM_urlStr & "0" MM_moveLast = MM_urlStr & "-1" MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size) If (MM_offset - MM_size < 0) Then MM_movePrev = MM_urlStr & "0" Else MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size) End If %> iaminawe imagineering version number three
 
 
<% While ((Repeat1__numRows <> 0) AND (NOT RS_CurrentEvents.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 RS_CurrentEvents.MoveNext() Wend %>
NEWS
<%=(RS_CurrentEvents.Fields.Item("pubdate").Value)%>
<%=(RS_CurrentEvents.Fields.Item("Title").Value)%>
<%=(RS_CurrentEvents.Fields.Item("description").Value)%>
 Articles <%=(RS_CurrentEvents_first)%> to <%=(RS_CurrentEvents_last)%> of <%=(RS_CurrentEvents_total)%>
<% If MM_offset <> 0 Then %> +--previous <% End If ' end MM_offset <> 0 %>
<% If Not MM_atTotal Then %> next--+ <% End If ' end Not MM_atTotal %>
 
RECENT WORK
Visit Corne and Twakkie The Most Amazing Show
Its Corne and Twakkies new most amazing website with cool new movies, comics and tunes.
Jazz down with Zouq Zouq
An interesting website and ID for this Fish Hoek based rock, roots,jazz and blues band.
View the operatic animation The Aqua Opera
Animated visuals for a recent Opera held on a floating stage at theCape Town Waterfront.
View the music video David Kramer
An animated Afrikaans music video featuring motion graphics and live footage.
View the video Appletiser
Animation and Motion Graphics visual mix created for this travelling exhibition for Appletiser.
Book Cover Designs Oshun Books
Name, identity and book cover designs for this new womens publishing imprint.
Fishermans Birthday Stills The Fishermans Birthday
This animation was created for projection behind this piece of childrens theatre.
Impact Consulting animation Impact Consulting
This animation was used at the launch of this new company and will also be posted off their site.

Visit www.jocastarising.com

Jocasta Rising
ID, site, viral e-mail, print and animation for this theatre production

Visit www.goldfishlive.com

Goldfish
ID, website, CD-ROM Press kit and promo material for this talented duo.

Visit the New Day Site

New Day
ID, website, print and animation for this theatrical democracy celebration.

Visit www.iaminawe.com/chaos Chaos in Motion
Experimental motion graphics in the form of three one minute videos
Visit www.africanlabyrinth.com African Labyrinth
Website and animation to promote the labyrinth design of Anni Hennop
Visit www.iaminawe.com/tshirts Cityflauge T-shirts
iaminawe created this limited edition set of original t-shirts
Visit www.lawactive.co.za Lawyers Access Web
Corporate ID & website design for this dynamic law firm.
ABOUT

So what is iaminawe? Who is iaminawe?
T
his probably is not going to answer all your questions but it does give you a peek behind the messy mind machine that is iaminawe.
FIND OUT HERE

CONTACT
iaminawe imagineering

info@iaminawe.com

+27 (21) 7826147
+27 (72) 2429766
Cape Town
South Africa
SOLDIERS OF IAMINAWE
Are you ready for the re-evolution? Keep up to date with iaminawe and receive random inspiration via e-mail.

This revolution just got pixelised.

<% If (Request("signup")) = ("") Then 'script %> <% End If ' end If (Request("signup")) = ("") script %>
<% If (Request.QueryString("signup")) = ("affirmative") Then 'script %> THANKS FOR SIGNING UP
PREPARE FOR CONSCRIPTION <% End If ' end If (Request.QueryString("signup")) = (affirmative) script %>
CLIENT LOGIN
 
 
 
<% RS_CurrentEvents.Close() Set RS_CurrentEvents = Nothing %> <% RS_Webwork.Close() Set RS_Webwork = Nothing %>